I am required to use a Word file for our estimates. I am trying to create a layout so similar (in FM) that my boss will let me use my database verus word to write the estimates. The problem is we have a lits of possible iproductes in a list in the word file and most are not used in every quote.. is there anyway to create a field with a large amount of data with the ability to edit it on the fly? look at this word file - it will help with my question

Edited July 22, 200718 yr by Guest
Removed

It is possible to print something very similar from FileMaker, though it is a bit tricky. There are a couple of methods. The first is to use FileMaker Layout Parts, Subsummaries, Trailing Grand Summaries, etc.. If that doesn't quite do it, you can resort to a Copy/Paste method with global fields.

This requires a fair amount more work, but gives you added flexibility. Basically you go to the records you want, for each "section" (and these can be from the same table, or other tables), and use the Copy All Records step to put them all on the clipboard. Then you paste what you got into a global field. You can have several global fields for different sections (or a repeating global, but I was having trouble getting them both to slide up; maybe because they were not connected? sliding is sometimes a black art).

A 3rd extension of the above method would be to build everything successively into 1 global field. That would allow you to edit it afterwords, or even copy/paste it into Word to mess around with. But it would mean that all your layout text would need to go into global fields first, as you cannot copy/paste/set layout text with a script.

FireParts.zip

Hi,

I am new to the "Forum" and its "rules" however, may I ask you a question? I have a multiple table contact management database, I want to copy the name and address from the main table into the same fields in the second table then create a new document. Would someone be kind enough to share what I am missing here...

Frank

Thanks again for your help. My low tech solution was to create 7 new fields that would auto-enter less than 250 characters and then I can edit it to what I need (right in the browse mode). I used sliding to make it look like it was typed correctly when printed- clunky but works well.

Thanks again for your help

Peace

hello again,

do you know a way to remove the PDF I uploaded for you to look at? A co-worker found it on Google Search and it caused a bit of a thing as one of the owners thinks it is not a ggod thing to be out one the "web".... thanks

Hi Adam,

I have removed the PDF as you wished.

Lee

thanks!!