Auto update another table

[Gismo1233]

Hi all,

Please could you assist?

When I add a part number and description to layout x, I need the part number to automatically be added to my parts catalogue if it does not exist

How do I accomplish this?

I also want duplicate part numbers to be automatically be deleted

[Søren Dyhr]

You can prevent it happening in the first place, by setting the validation to "Unique" and turning the "...overide" off!