Welcome to the forum
When designing the tables, set the description field "Indexed" property to "Yes (No Duplicates)".
For the Products table, the fields might be:
Field Name
|
Data Type
|
Property |
Value |
comment |
ProductID_PK |
Autonumber |
|
|
Primary key |
ProductDesc |
Text |
Indexed |
Yes (No Duplicates) |
|
Data
ProductID_PK
|
ProductDesc
|
1 |
Pipe |
2 |
Cable |
3 |
Conduit |
For the Products Type table:
Field Name
|
Data Type
|
Property |
Value |
comment |
ProductTypeID_PK |
Autonumber |
|
|
Primary key |
ProductID_FK |
Number |
Field Size |
Long Integer |
Foreign key to Products table |
ProductTypeDesc |
Text |
Indexed |
Yes (No Duplicates) |
|
Data:
ProductTypeID_PK |
ProductID_FK |
ProductTypeDesc |
1 |
1 |
PVC |
2 |
1 |
CARBON STEEL |
3 |
1 |
STAINLESS STEEL |
4 |
1 |
RGS |
5 |
2 |
POWER CABLE |
6 |
2 |
HV CABLE |
7 |
2 |
CONTROL CABLE |
Same idea for following criteria tables....