Access Auto populate

  • Thread starter Thread starter Glenn Heavens
  • Start date Start date
G

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
 
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
Click to expand...
--------------------
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,
 
Back
Top