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

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