Hey,
I ahve made a database containing two tables in Access and they are linked with a 1 to M relationship. I ahve made a form from one of the tables and on the form is a box where the user enters the id of the company associate with that product. Instead of the user having to find the id and then enter it into the text box. How can I get a combo box to appear and it auto fill with the names of all the companies from the companys table and when the form is submitted then the correct id appear in it's place?
I ahve made a database containing two tables in Access and they are linked with a 1 to M relationship. I ahve made a form from one of the tables and on the form is a box where the user enters the id of the company associate with that product. Instead of the user having to find the id and then enter it into the text box. How can I get a combo box to appear and it auto fill with the names of all the companies from the companys table and when the form is submitted then the correct id appear in it's place?