Auto populating a table????

[Ronnieatwarton]

Here is my problem:
I have a table (BillOfMaterials) where every part used on an asset is entered.
I would like to create another table that is populated automatically when a new part is entered into the BillOfMaterials table. However This table should only have unique parts so it will only populate "new" parts and not if they already exist.
Is this possible????

 

[johnnymac43]

If each part has a unique part number, and this number is used on all BOM entries, the answer is yes. There are many ways to do this, and the codies will no doubt suggest their favourite methods.

Do you have the option to change your data structure to avoid storing the part details (other than number) more than once in your BOM table? If you can do this, and want to do so, the best solution will be one that maintains a table of unique parts, and stores the ID numbers of the parts in the BOM table.

Cheers

John