General information
Category:
Coding, syntax & commands
Hi Mary-Ann,
I would use the following tables structure:
Products
===========
PK I
Desc C (50)
ProdSpecs
=========
PK I
FKProd I
FKSpecs I
Specs
===========
PK I
Desc C (50)
Products.PK is linked with ProdSpecs.FKProd (1 to n) and Specs.PK is linked with ProdSpecs.FKSpecs (0|n to 1).
The table Specs contains all 35 different specs. In the ProdSpecs table, you insert one record for each spec you want to display for the given product.
HTH
>Have a table of approximately 35 product specifications. Not all the products have Each spec tested for. Currently have one form with all the specifications listed and the user fills in the ones that apply to that product. Want to have it recognize the Type of product it is and only bring up the specs (fields) that apply to that product. Do I have to have Separate Tables with the different types of specs?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only