Create Access 2010 Sales Form with many products in 1 field?

[ahamzawy]

I am an access newbie.



I want to create a form for Sales. Where every order placed in field OrderID, for products I set field OrderedProducts to look up products database. Everything is fine only that I donno how to set more than 1 product per order.

What if I want to order more than 1 product? I'm thinking about creating another OrderProduct#2 and OrderProduct#3.. etc? I'm sure there's a better way to figure this out.

Thank you!

[ketbdnetbp]

You might find these useful:

http://www.rogersaccesslibrary.com/forum/topic238.html

http://www.databaseanswers.org/data_models/customers_and_invoices/index.htm


All the best,

Jim