I have set up my sales database with an order form as a main form, and three tabbed subforms within it. Two of the subforms are children of the Customer table; one being Shipping Addresses. Many customers have multiple shipping addresses and only one billing address. For any order, I would like to select one of the shipping addresses and have the identifying info (ShipAddID) added to the current record in the Order table (fkShipAddID). The Shipping Address table has two identifying keys, one for the Customer ID and the other for the Shipping Address ID.
I created a button to do this when the appropriate shipping address row is selected, but not sure of how to write the code to tell the order record to use the particular address. Is this a VBA code or a Macro?
Thank you for any advice. DB attached. v4.3e - Copy.zip