info from pulldown menu and store it in another table
Hi All,
Who can help me?
I made a master table in access with 6 headers in it, like below
Another table has my customers in it, with company nr, company name, address, zipcode, place, and country, I also have a query from the customers ascending on the customer Nr.
I would like to make a form with a cell with a pull down bar, it should show the customer nr, if I select this it should store all the info from that customer in the mastertable in the same named cells.
How can I make this?
Thx in advance,
Willem
Hi All,Who can help me?I made a master table in access with 6 headers in it, like belowAnother table has my customers in it, with company nr, company name, address, zipcode, place, and country, I also have a query from the customers ascending on the customer Nr.I would like to make a form with a cell with a pull down bar, it should show the customer nr, if I select this it should store all the info from that customer in the mastertable in the same named cells.How can I make this?Thx in advance,Willem Read More