Lookups

  • Thread starter Thread starter NK
  • Start date Start date
N

NK

Hi folks,

I've read through as many posts as I can but I would appreciate some
help in the following:

I am trying to create a form for data entry in Access 2000. The first
box is a combo box that drops down a list from a table I have created
and saves the entry in another table. What I want to do is have a
second box underneath that automatically picks up an entry depending
on the input to the first box and saves it in the same table as the
first box is saved. For example, if John is number 1 and Jane is
number 2 then if I select number 1 from the combo drop-down box then
the entry below changes automatically to John and will save in a new
table. I already have a table with all the names linked to numbers.

Any help would be gratefully received.

Niall.
 
For example, if John is number 1 and Jane is
number 2 then if I select number 1 from the combo drop-down box then
the entry below changes automatically to John and will save in a new
table. I already have a table with all the names linked to numbers.
Click to expand...

I'd suggest storing either the number or the name in your data table -
NOT both! If you can always look up the value 1 and find John, then do
so; storing John's name redundantly is neither necessary nor good
practice.
 
Back
Top