Strouss

I'm trying to join my existing customer management database with the "resource scheduling" stock template that comes with FM7. I could implement a dispatch facet to my existing database with this. I know one can import scripts and records. Is it possible to import tables, relationships, and layous from another database file?

Thanks Folks. I'm really surprised there isn't anything. It seems to me to be such a common need...maybe not.

I am having trouble finding a faxing plugin for FM7. I really don't know why. I need to send estimates and followup faxes to customers from my database (I just print the layout). We use a fax printer on our server for all of our faxing. Can anybody help with this? Windows XP to 7.

My customer database is crossing looked up data. The lookup is based on a site number text field that sometimes has a "0" on the end of the number. We have customers with multiple work sites. Our site number works like this. "CustomerNumber.HowManySitesCalculation" So if we have 9 sites for this particular customer and we ad a site that new site is "CustomerNumber".10 I have changed from dashes to decimal points because the lookup didn't "see" the dashes. The lookup is crossing information from site number 1143.1 to site number 1143.10 I believe it drops the last 0 in the lookup because it not numerically necessary and pulls information from the first record it finds. I changed the field from a number to a text field with no improvement. My crew showed up at Archstone San Jose to do what they were supposed to do at Archstone Walnut Grove. Is there any way to get filemaker to recognize the 0 on the end. Would a different type of field work better?

Is it possible to put a merge field into a global text field? On my "estimate" layout I have a scope field that copies a global field on a different layout. I would like info from other fields in the estimate record to be included into the global field via merge fields. Is this possible?

thanks guys

Sounds alot like my post #124355 Buggy Graphics.

I am a business owner that is designing a solution that fits my organization very well. How would Developer 7 benefit me over Pro 7? Would it be worth the purchase? The only thing I can see would be the script debugger but I'm not sure I would use that much. Any Comments?

Thanks for the scripts. Now preview mode shows all of the records in the table in 6 pages. There are only 3 and they are all 2 pages long. It only prints the 1 record but the page numbers show 1of6 and 2of6. I had a little trouble with the sort in the "print My Report" step. In order for it to show "Sort [Restore, No dialog]" I have to select a field. Is that right. As well, What does this do """"? in the "print Setup" script under Set Field. It won't let me enter that calculation. Filemaker automatically changes it look like this """". What does the "Freeze Window" script step do? Here is my scripting I must be doing something wrong. "Set Page of #" script Enter Preview Mode [] Go to Record/Request/Page [Last] Set Field ["TotalPages", "Get(PageNumber)"] Go to Record/Request/Page [First] "Print Setup - Letter, Portrait, Records Being Browsed" Print Setup [Restore, No dialog] Perform Script [sub-scripts, "Set Page of #"] Print [No dialog] Set Field ["TotalPages", """"] "Print My Report" script Freeze Window Sort [Restore, No dialog] Go to Layout ["PacconEstimate"] Perform Script [sub-scripts, "Print Setup - Letter, Portrait, Records Being Browsed"] Go to Layout [PacconEstimate]

I am having a problem with a layout that I am using as a contract. The layout is "Stock" 3 pages long but when in preview mode slides up to anywhere from 1-1/2 to 3 pages in length. It does this because I have a series of large text fields that shrink to fit the text within them. I have inserted a page numbering script that displays the page numbers as "Page 1of3". The numbering system works great! Here is my problem. The layout automatically wants to print 3 pages even if the last one is blank because that is how long the body of the layout is. My specialized numbering system doesn't jive when the last page of the contract says "Page 2of3". This is the conversation I envision with my clients. Client: "Hey Matt we received your contract, your service looks like it would fit our needs perfectly and your price is just below the competition's." Matt: "Great! just sign and return it and we will get back to you with a start date and schedule". Client: "Well we would but you have only given us 2 pages of a 3 page contract! What are you trying to pull Mr. Strouss? Do you think we are idiots? I can assure we are not! We have decided to go with the competition because of your contractual issues." Matt: "AAAHHHHHHHHH"!! Now this may be a slight exageration. My customers tend to be very nice people as a whole. I do however need to get this problem resolved. Why won't the footer and body of the layout slide with the rest of the document?

I'm there as well

I will.

I'm glad someone else see's it. I thought maybe I needed to move the annual MRI date forward. Thanks folks

Hello Lee, Your right I should give more info. When I say "Graphics" I mean layout elements. Lines and drawn boxes as well as fields. I don't have any pictures or any actual artwork. None of my layouts are large, very minimal. No big graphical objects. I didn't know you could layer things in filemaker. In this instance I have a colored box drawn over the body with fields on top of that. Would this be considered layering? I get shadowing, lines are cut and misaligned and half fields among other problems. It can get so bad that I need to close the file and reopen it so that I can see what I am doing. Sometimes it even carries over into browse mode but the file prints OK. As a fact when it prints, it corrects the screen. As I said it has been going on for years over multiple versions on multiple computers with multiple files old and new. That is why I thought it was a bug. Maybe there is a particular setting in Windows that I activated and the two are conflicting. Thanks again, Matt

Thanks for the reply Reed. I first noticed it when I upgraded from 4 to 5. It seemed to follow file conversion. Are there any known problems with converting files to new upgrades. It is also happening on a brand new file that I'm working on in 7.