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]

"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.

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.

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)

OK, my FileMaker brain came back to me.

I lost somewhere. But...

It's fixed and working fine.

Thanks