See description, record ID in table

  • Thread starter Thread starter John Smith
  • Start date Start date
J

John Smith

I have a form that I want add a combo box to that will display one
field and record a different field in the actual table. In other words
....

One of the fields in my table, "Clients", is Ethnicity. I want to
create a combo box on the data entry form for that table that displays
values from a table called "Ethnicity". I want the drop down menu to
display Ethnicity.description. However, when an ethnicity is selected,
I want the Ethnicity.ID_numb for the respective row to be recorded in
the database. (It's a less complex field to query on.)

I am using MS Access 2002 and MySQL through ODBC. Any suggestions on
how to do this?

-john smith
 
Give the following a try

1. The Select statement in the recordSource property should
select both columns from your Ethnicity table.
2. Set the number of columns property to 2 and make the
width of the id column 0. (Multiple column widths are
expressed with ; as a seperator)
3. Set the Bound Column property to 1 if the id column is
the first in the select statement or 2 otherwise.

Hope That Helps
Gerald Stanley MCSD
 
Back
Top