Jump to content
Sign in to follow this  
Fred Rogers

Printing a list of records on to a form letter

Recommended Posts

Fred Rogers    0

Ok, I am new to FileMaker so please ask any questions if I leave out an important detail.

What I am trying to do is print a letter that has a variable amount of information in it. 

I have a table with clients and a related table with invoices in it. 

What I would like is a letter that has some client information at the top, ie our logo, the date, and the client's mailing address, then a little message about the invoices. Then I would like it to print all the out standing invoices number, date, and description. (all fields in the invoice table) and end with a nice statement with the total number of outstanding invoices and please pay etc. 

I tried making a list layout using the invoice table with all the client info in the header, then the information I wanted in the body, then closing statement in the footer. 

Something like:

Header: Logo, <<client::address>>, dear <<client::fullname>>

Body: Invoice numb:<<Invoice num>>  On <<Date>> work done: <<Description>>

Footer: Nice message with a total and please pay etc

When I run the script to go to related records, do my find and sort by script it looks ok. All the invoices are listed.

But when I print the layout it breaks each invoice record in to a new page. ie

Header

Invoice 1

Footer

Header 

Invoice 2

Footer

etc

How Can I get a print out like looks like:

Header

Invoice 1

Invoice 2

Footer

I am so close on getting the letter done. I have the scripts selecting the correct invoices. Now I need to get all the invoices printing in the middle of the header and footer and I will be good. 

Help!!

-=fred=-

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.