Field 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
 
Glenn

Why post four times on the same issue?

If you have a table in which you have used the lookup field type, you will
encounter confusion, since Access stores one thing (the key from the looked
up table), but displays something else. A scan through the "tablesdbdesign"
newsgroup will reveal a very strong sentiment against using the lookup data
type in defining table fields.

Second issue: if you have the same data in more than one table (e.g.,
"Company Name" in Table 1 and Table 2), which version is correct? How do
you keep these two in sync if one of them is changed? And if it isn't a
good idea to have data duplicated across more than one table (it isn't a
good idea, see also the "tablesdbdesign" 'group), why would you need/want to
duplicate VendorNumber?

Third issue: if (somewhere, in some table) you already have a VendorNumber
associated with a CompanyName, you don't need to record that relationship
again.

I'd suggest taking a look at the topic of "normalization" in Access HELP --
from your description, it sounds like this may be data imported from a
spreadsheet. Access, as a relational database, has some capabilities you
won't find in Excel, but only if you organize the data relationally...
 
Back
Top