multiple line entries in a table

[Steamer35212]

I am using the Lookup Wizard to create a list of camera accessories for a checkout db. It is necessary to enter more than one accessory per camera. Is there a way to do this with Lookup Wizard or is there another method that should be used.

 

[randysmid]

Hi,
Personally, I would have 3 separate tables.
1) The first table would be a master table, with all items included, regardless of whether they are accessories or master items. Obviously, one accessory can be used by multiple master items, such as a power cord for a bunch of different video cameras. This table would be composed of a productID or SKU number, description, brand, price, etc.

2) The second table would only contain productID's for those items designated as master items, such as television, video camera, etc.

3) The third table contains the productID's for the master items along with the productID's for any accessories for this product.

Maintaining the database will be alot of work, but it will be very successful in the sense that every accessory for each master item will be readily found. In practicality, a form would be created that maintains the second table, and contains a subform containing all the accessories from the third table.
HTH,
Randy Smith
California Teachers Association