Select products for an order via check boxes in Access 2010 I have a lookup table where I have defined some products. I have another table that defines orders. This table defines which products is in the order by having a ID that is linked to another table that has a link to the orders table and to the products lookup table.

Lookup products:

ID: 1
PName: Basketball

ID: 2
PName: Football


Orders:

ID: 1
Products: 3

ID: 2
Products: 5


Products:

Products: 3
PID: 1

Products: 5
PID: 1

Products: 5
PID:2


So in the orders table, one can see that Order 1 has ordered a Basketball, while Order 2 has ordered both a Basketball and a Football.

Now, when you place an order in the Place Order-form, I want the user to be able to choose between the available products, and let them pick them from a list of checkboxes. How is this possible? (When the shop manager adds another product, it is automatically added to the list.)

Is this the correct approach to my problem, or is there a better solution to this?

Edit: I found a solution to this. One could use a list you can select the product, and press an arrow button to add it to another list. The same way you choose fields when making a combo box.
You have an order/order detail set-up and this means the easiest way is to create an order form with a detail subform. The subform should be based on the table Products illustrated above, with a combo box for PID drawing the row source from Lookup products. The link child and master fields will be Order ID. 

You can see something like this illustrated in the Northwind sample file. The sample files should not be followed exactly, they are only illustrations. In particular, the code is inclined to be a little dodgy.