I'm working on an MVC 3 website for a small business which has a database containing a few tables. There is a table for Products, a table for Feedback, and the table this question is about: Orders.

For placing orders, I have set up a shopping cart. When the user is ready to check out, they enter some info and arrange for a pickup date. This "Order" is then saved the database, where the Admin(s) can then see and respond to. I need to save the products from the shopping cart in a list, which will be contained in an entity called OrderInfo.

My question is, how can I set up a relationship between tables (foreign keys) to get a new table which associates OrderIDs with the Product entities that are on those orders?