Hi
Background
I have a form with two combo boxes on it. 1. Supplier and 2. Supplier Part. These work fine and are used to either check a record of a supplier/part exists or to select a record of a part in the system and create a "complaint" for it. I want the Part number to copy over to the Complaint form for a new record when I click on a command button "create complaint".
Problem
I can't figure out how to get this to work. The record in the complaint form is using "PartSupplierID"; from a transaction table. i.e. the complaint is against a suppliers part, as a part can have multiple suppliers. Attached is a jpg of my stucture.
I think once I have been shown how to do this the other (similar) problem with two other forms I can solve myself. hopefully.
Many thanks for any help,
Robin
Background
I have a form with two combo boxes on it. 1. Supplier and 2. Supplier Part. These work fine and are used to either check a record of a supplier/part exists or to select a record of a part in the system and create a "complaint" for it. I want the Part number to copy over to the Complaint form for a new record when I click on a command button "create complaint".
Problem
I can't figure out how to get this to work. The record in the complaint form is using "PartSupplierID"; from a transaction table. i.e. the complaint is against a suppliers part, as a part can have multiple suppliers. Attached is a jpg of my stucture.
I think once I have been shown how to do this the other (similar) problem with two other forms I can solve myself. hopefully.
Many thanks for any help,
Robin
Attachments
Last edited:
