Query to get data automatically

D

David

Hello,
I got a table with name and several data of a company.
And I need to make a query to insert the company name and data and then
another information.
How can I make the query so that when I select the company's name from a
combo box, he inserts automatically the other data, like address, phones, etc.

Thanks in advance.
 
J

JohnFol

That sounds like you are repeating the company data in 2 separate tables. Is
this the case?
 
J

JohnFol

What you would typically do is store the Company ID as selected in the
combobox in table2.
 
Top