How display all 3 items on report without..

[mr1sparkle]

I need to make the exact same copy of this invoice with access. On the report, I want to show each customer with all the items (brother pt-pc, tapes and toner cartridges)they've ordered. Im only able to display one customer for one item for each page. Help


Invoice
[IMG] Uploaded with ImageShack.us[/IMG]

I need to make a compsite key to do this. Is there anything wrong with the composite keys.
[IMG] Uploaded with ImageShack.us[/IMG]

[pbaldy]

I don't understand why the product table would contain a customer field. I'd also have a price field in the invoice detail table. Price changes over time, and if you join to the product table for price you'll get the current price on old invoices.

Your invoice would generally be represented with a form/subform or report/subreport.