If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Auto populate
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, -- Eric Cárdenas Senior support professional This posting is provided "AS IS" with no warranties, and confers no rights. |
Thread Tools | |
Display Modes | |
|
|