Thanks.
This solution looks simple.
However, is it possible for the subform to be linked to more than the "joint table" alone? Because in this situation, the main form is just a selector of items already on the tblBOM. I intended to add a new component under the selected customer on the...
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...