table combo box look up

  • Thread starter Thread starter jeff
  • Start date Start date
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-
 
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
 
Back
Top