Multiple Entries Per Record?

[barfnuts]

Hi there,

This may sound incredibly amateurish, but I can't seem to figure this out... I'm using Microsoft Access to make a database at work for a shipping manifest, which houses all the invoices for product that is being shipping out for any particular day. Here it how it's set up: Invoice#, PaymentTerms, CustomerName, ProductID, Quantity, Serial Number and Notes. For every customer there could be multiple items per invoice, yet I can only put in one entry per record. Am I making sense or am I just a bumbling fool?


Thanks, any help is appreciated.
Travis

 

[lespaul]

First, read The Fundamentals of Relational Database Design.

Leslie