Access Auto populate

[Glenn Heavens]

I have an Access Database with two tables. In Table 1 say I have Company
Name and Vendor number. In Table 2 I have a Company Name using a Lookup
Wizard and that works. But what I want is when I select the Company name in
Table Two I want the Vendor number in table 2 to auto populate with the
number associated with it in table one. Get it. If further information is
required please let me know. I am using Microsoft Access 2002
(10.6501.6626) SP3. Thanks in Advance

 

[Eric Cárdenas [MSFT]]

I have an Access Database with two tables. In Table 1 say I have Company

Name and Vendor number. In Table 2 I have a Company Name using a Lookup
Wizard and that works. But what I want is when I select the Company name in
Table Two I want the Vendor number in table 2 to auto populate with the
number associated with it in table one. Get it. If further information is
required please let me know. I am using Microsoft Access 2002
(10.6501.6626) SP3. Thanks in Advance

--------------------
You need a query that joins Table 1 and Table 2. This should take care of
the autolookup.

For an example, lookup the Orders form from the Northwind traders database.
When you choose a customer, the shipping address is automatically filled up.

Hope this helps,