Hi,
I'm a beginner using access, having gotten down the theory and best practices to some extent.
I have 6 tables: Customers, Orders, Products, Order Details, Shipping, Invoices. I have created all the fields and related the tables to one another. Now, if I have one item on an invoice everything works fine. But I didn't allow for multiple items on an invoice which is the case most of the time.
What is the best way to handle this situation in designing the database? Looking for the simplest solution. Any help would be greatly appreciated!