Trying to figure out:

I have a database with 4 files. Two are information files that are accessed for two or three fields; one is a line items file and the last is the one that ties them all together (invoicing).

My question is, where to design the print layout? If I create it in the last file, it has to be a portal of the line items, but I haven't been able to figure out how to get it to print over multiple pages. When it comes time to print an invoice, how is it done?

Also, is there a way to make the first page in one layout (like with logo and mailing window layout) and make the rest of the pages just of the line items info?

You need to print from the "end" file, this is correct.

Printing with portals is wrong. They are not designed for printing.

You will create a layout in your line items table and use the "list view" and enter preview mode to see your summary totals and such.

I have attached a model file for your review. It will show you a simple technique for printing from Parent to Child.

If you have any questions, just reply to this tread, I will try to accommodate.

GOOD LUCK, hope this helps.

That was just what I needed... Thanks!

I had created a basic table layout for the line items file and it just didn't hit to make a print layout there (the 70's were rough on me...)