Each table should have a number field that is an autoentered serial number. Typically something like ProductID in the product table. Another table, say Accessories, would have AccessoryID.
To associated an Accessory to a Product, assuming that each product could have multiple accessories and each accessory could be added to multiple products, you would need a third table that would hold the combinations of Product and Accessory IDs, called a Join table.
The relationships (connections) would then be
Products::ProductID = Product_Accessory::ProductID
Accessories::AccessoryID = Product_Accessory::AccessoryID
You might also set up a related "details" table with three fields (assuming you can always enter the details as text, otherwise you may need a few more fields.)
ProductID, Detailname, DetailData
A Portal to this details table could be set up with a dropdown list of values for detailname and an edit box format for detail data.
To list the details for a specific product, you select, such as GB or Megapixels in the drop down and then enter the value associated with it (130 for a 130 GB HD for example). This gives you a generic list you can build to any needed length to list details about the product.
thanks for your answers!
indeed a many to many relationship leads to a better result ...
great idea, that of the portal, I think I'll start from here.
thank you again.