I have all my estimates, orders, invoices in a Filemaker 4.0v1 database that then print out on A4. Sometimes the estimates need to be more than one page. How can I get to run out a second page using the same calculations without creating a new record which would make a new calculation.

Cheers

Judy

On your printing layout, make you fields and body part larger so that they extend across multiple pages. Set all the fields to "slide up" and "also reduce size of enclosing part". This will print the number of pages necessary to encompass the contents of the fields. -bd

Update your copy of FMP to 4.0v3 -- lots of bug fixes were made.

The update is free from http://www.filemaker.com/

Thank you very much LiveOak. I have done this with success with text fields and repeating fields but I am still having a problem with the result of my calculation. Where do I put it?

I have a vertical row of repeating fields which go down 2 pages and if I put the result (total) below these repeating fields it is ok when the estimate goes on for 2 pages but when it is short and only one page, the result is on the second page.

Where do I put the result?

Repeating fields.... aaarrrrgggghhhhhh!

Get rid of the repeating fields. Replace them with relateds fields.

[This message has been edited by Vaughan (edited February 14, 2001).]

Create a calculation field that concatenates all of your data into a single, formatted text result - and yes, you can get the data from the repeating fields.

ReportTxtField = GetRepetition(RepField1,1)& "