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.
ID: 1 PName: Basketball ID: 2 PName: Football
ID: 1 Products: 3 ID: 2 Products: 5
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.