Multiple Page Form

[Baylah]

I have always wondered if this is a possibility in FileMaker, and as I have started to develop DB's for people other than myself it is becoming an issue that I must know the answer to, and if there is not an answer what some people use as work around solutions.

After I develop an Invoice or PO type Form there are many instances when a user will need to use more "lines" than are available on one printable page of a layout. I have always had to create a second record and then continue on.

Two of the two obvious downsides is you would not get a grand total on the second page and sequential numbering would be off because I really want the second page to have the same PO or Invoice # as the first page.

I have developed some work arounds for both of these issues, but they are not very elegant and I wondering if anyone has any suggestions? Have I just been using FMP wrong all along? Is there a simple soultion I am missing?

I have never come up with a grand total solution I like, I mean I have done it as a summary field, but then I have to script it to display only the "orders being browsed." with a similir PO or Invoice number.

Can anyone H.B.O.? (Helop a brother out!)

Oh, and one other question I have always wondered about.....Is there a way to auto-post or scirpt an addition to a value list? For instance, on my PO DB, it would be wonderful if my user could just hit a button and then post the contents of the Product ID field directly into the value list that is a drop down menu. This might be the wrong forum for that question but I thought I would throw it out there.

Thanks,

Steve

[Ender]

You haven't said much about your structure, but a typical structure for an Invoice (or PO) system is one table for the Invoice and another table for related Line Items. A Product table may also be used if the same product is frequently sold (or purchased).

With this structure, an Invoice has many related line items, editable through a portal. Portals can have an unlimited number of lines, so long as you have the scroll bar turned on.

For printing, you'll get the best results by jumping to the related line items, and using a columnar report with sub-summary parts. A summary total field in a sub-summary by Invoice# part should show the total for the invoice. To 'jump to the related line items,' use a Go to Related Records [ Show ] script step.