Multiple page invoice layout

[mcss]

I have any invoicing system. Databases - customers and sales items. Customers has a layout - Invoice. Some customers that have a small amount of sales items, they only need a 1 page invoice, but a some customers need a 2 page invoice. I can't figure out how to get Filemaker to continue the sales items on the second page of the invoice. I'm using a portal in the customer database, and linking the sales items fields.

ideas??

Thanks [email protected]

[Vaughan]

"I'm using a portal in the customer database..."

Try printing the invoice from the related file, so it becomes a simple list of records.

Put the company info into a Leading Grand Summary part (bring the company info in through a relationship). Use the Go to Related Record script step in the main file to select the appropriate records to print in the related file.

[AudioFreak]

Vaughn is correct as usual. Also keep in mind ...if you are printing the portal on a mac it probably will not print well on a pc. This totally bit me in the butt when I set up my first solution for a company that used all pc's. It all worked great with no problems on my mac. On their pc's........Not happening .

Take Vaughns advice before its too late.

[mcss]

Vaughan, thanks for the fast response.

I think I follow you;

- Build invoices layout in the sale items db (no problem)

- Relate the customers in a leading summary part. (no problem)

The related record script throws me??? explain a bit more.

THANKS

Larry (Mac)

[mcss]

OK, my FileMaker brain came back to me.

I lost somewhere. But...

It's fixed and working fine.

Thanks