Have you built this from scratch, trying to adapt the Invoices starter solution or perhaps some other file?
If it's your own design, check these details:
Two tables, Invoices, LineItems
Invoices::InvoiceID = LineItems::InvoiceID (Invoices::InvoiceID should be an auto-entered serial number, enabl allow creation of records via this relationship for LineItems.)
On the invoices layout, put a portal to lineItems.
Now entering a customer's list of items purchased should be a simple as entering the information in differnt lines of the same portal.
Here's a good, basic invoice demo file created by Comment: http://fmforums.com/forum/showpost.php?post/309136/
This Filemaker Help Tutorial uses Invoice as the example
Relational Database Design 101 (part 2 of 3)
Relational Database Design 101 (part 3 of 3)
I tried the method as you suggest. What I am working with involves an adapted from the invoice starter solution. I still encounter the same problem, and it appears that the link from the other forum, when one goes to print out the single invoice, it prints as multiple invoices for the same invoice when the customer orders more than 1 product.
Example Invoice for John Doe
Product ID Product Name Qty Price Invoice Total: $175
1 Book 1 2 $50
5 Series ABC 1 $125
but it prints 2 invoices, one for the Book1 and another for Series ABC. I am very new to FileMakerPro and do not fully comprehend how exactly a portal feature works.
I only see one invoice with two items in this last post. How is this two invoices?
When trying the demo, did you just select the layout or did you run the script in the script menu? (The script pulls together just the line item records for the current invoice together in a found set and sorts them so that the proper headings appear.)
This might solve your problem:
Go to the invoice layout that you print from, then click the Layouts menu > Part Setup > double-click "Body". Then UN-check
"Page break before each occurence".
Thanks y'all for all the helpful info! I finally got it to print the invoices the way I needed.