In our industry some parts are identified by multiple unique part numbers. Items are referenced by part numbers only and the part number will be the primary key.

For example a part has the following unique part numbers all referencing the same product:

Part Number 1:                 571889-001
Part Number 2:                 484275-001
Part Number 3:                 484274-001

 

I am creating a form “Add Part” and I would like to add all these 3 part numbers referencing the same product with a common “Part Name” and “Part Description.”

 

These are my requirements:

1. Part numbers must be unique and cannot have duplicates.
2. Parts must be searchable by any of the 3 part numbers.

 

Please let me know how I can achieve the above.