I am trying to create queries in a database and having problems figuring out the database structure. My database holds product information. Many products can be sold with others as add-ons. How do I store the product in the database so I know which products it can be sold with. <BR><BR>Example: In a drop-down box a user selects a nike shoe ( which is a set to have a reference code of 3). I search the database for all add-ons with reference code 3 and display them. "Shoe laces", "shoe polish", and "shoe inserts" all come up as options. Now the problem is that the same "shoe inserts" are sold with many products. Do I have to make redundant entries of "shoe inserts" with differnt reference numbers or can I somehow store all 8 pairs of shoes they can be used as ad-ons with in one databases entrie?