Combo Box

[pony08]

I have a combo box in a form that is used to populate one of the columns in a table. How do I get the description to appear in the table instead of the primary key?

 

[CJ_London]

You should not be looking at tables directly but throught a query. Although tempting, you can change the field definition to a lookup but I would resist this because it will cause you endless problems in the future

 

[pony08]

I appreciate the redirection!

 

[Cronk]

The whole idea of a relational database is related tables based on Primary/Foreign keys. So why not store the ID? If you must store the "description" in the lookup table, then set the bound column in the combo to 2