Orders Database

[jimd1768]

I know this is probably very simple but I do not know how to do it.
I have:
Table 1 - customers
Table 2 - Orders

At the moment, when a customer orders 2 items, I have to create 2 seperate order numbers.
I would like to have both items under one order number. Can anyone help with an easy solution.

Thank you

 

[RuralGuy]

Have you looked at the NorthWind db that ships with Access for such an example?