I am trying to develop a form that allows me to enter shipment tracking info (Fed-EX # and ship date) into a SHIPMENT table, select the customer, contract, and delivery address via a dropdown from a CUSTOMER table, and select one or more serial numbers from a PRODUCTDATA table to create a shipment record.
Since there is one customer to a shipment, I was able to set up a combo box on the form and select the Customer & contract info from the CUSTOMER table. This displays the customer, contract, and delivery address fields and saves the CustID PK from the CUSTOMER table in the CustID FK of the SHIPMENT Table. This seems to work OK when form is open to add New Record. However, If I open an existing record, I receive popups to enter parameter values rather than having the option to select Customer info from the combo box.
Note: A copy of the relationships diagram is attached in case I messed up on a link.
Any suggestions on how to set this up are appreciated.
Thank you.
Since there is one customer to a shipment, I was able to set up a combo box on the form and select the Customer & contract info from the CUSTOMER table. This displays the customer, contract, and delivery address fields and saves the CustID PK from the CUSTOMER table in the CustID FK of the SHIPMENT Table. This seems to work OK when form is open to add New Record. However, If I open an existing record, I receive popups to enter parameter values rather than having the option to select Customer info from the combo box.
Note: A copy of the relationships diagram is attached in case I messed up on a link.
Any suggestions on how to set this up are appreciated.
Thank you.