Unanswered: Display Relating record from Combo box
How can I display the related record from a combo box. The combo box selects from the supplier table. There are two records Supplier_Code and Supplier_Name.
It is the supplier code I need to insert into another table following selection. However on the form when the supplier code is selected I want to show the supplier name in a text box next to the combo box.
The form is a continuous form and will have many records displayed. So it needs to be able to show the different selection in the detail section.