table combo box look up

J

jeff

I would like to set a combo box that will read the values on a table that is
on the second column and puts that data on a different column on a different
table.
Example:
First Name on DB1 is on column 2 on customer list table

I would like a combo box that will read First Name on DB1 and place that
data on column 4 on DB2.

Thanks in advance,
Jeff-
 
J

jahoobob via AccessMonster.com

Use the combobox wizard. It will step you through the process.
 
J

Jeff Boyce

Jeff

If I am understanding your description, you are trying to do this directly
in a table.

STOP! Step away from the keyboard!

Microsoft Access Tables store data. MS Access forms display data (for
add/edit/...). What I believe you are describing would be better handled in
a form, not in a table.

STOP! Step away...!!

If you already have data in one table, there's rarely a need to redundantly
add that same data to another table in a well-normalized relational
database. If you'll describe why you are trying to do this, folks here in
the newsgroup might be able to offer an approach that meets your needs AND
takes advantage of the features and functions that Access offers.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top