The records does not update on the link table.
I have two tables (tblBOM and tblBOMCustomer) linked through a joint table (tblBOMCustomerLink). (database attached)
tblBOM
->BOMPartID (PK)
->BOMFileNo
->BOMTitle
tblBOMCustomer
-> BOMCustomerID (PK)
-> BOMCustomerName
tblBOMCustomerLink...