I have two tables: Customers and Invoices, linked on a one-to-many relationship, using the unquie "CustomerID field. The Invoice table is displayed in a Subform on the Customer (parent) Form. The Invoice table also has it's own unquie key field, "InvNumber".
The challange I have is that on the Invoice Subform, I want to be able to goto the Record matching a user chosen InvNumber, which they can select from a dropdown list. But that invNumber may belong to a different customer than the one currently being dispalyed on the parent, Customer Form. So the problem I have is, how, from the Invoice Subform, do I change the record on the (parent) Customer Form (using the CustomerID field) and then change the record on the Invoice Subform (using the InvNumber key field). Which would be the best method to use? If anyone can help, I'd be grateful. Thanks.