I have a main form with 1 subform. Relationships are set up between them with a ‘PurchaseOrderNumber’ (one side, an autonumber) as the parent field linked to the equivalent PONumbers on the subform (many side), the child. (RI is set between the tables with all cascades ticked).
I want other fields on the subform to be filled in automatically – so a ‘SupplierName’ & ‘InternalOrderReference’ on the main form and ‘SupName’ & ‘InternalRef’ on the subform are also linked, parent/child respectively for both.
It works fine but what I can’t get to grips with, and I’ve trawled this forum for a solution, is when I CHANGE the ‘InternalReferenceNumber’ combo box on the main form, it results in any existing subform records to be ‘orphaned’.
I suppose I may be looking for some code that will update/remove the subform records upon changing the combo box.
Any suggestions would be appreciated.
I want other fields on the subform to be filled in automatically – so a ‘SupplierName’ & ‘InternalOrderReference’ on the main form and ‘SupName’ & ‘InternalRef’ on the subform are also linked, parent/child respectively for both.
It works fine but what I can’t get to grips with, and I’ve trawled this forum for a solution, is when I CHANGE the ‘InternalReferenceNumber’ combo box on the main form, it results in any existing subform records to be ‘orphaned’.
I suppose I may be looking for some code that will update/remove the subform records upon changing the combo box.
Any suggestions would be appreciated.
