How do I display a value from a table based on a code from another table

[Will04]

Hi everyone,

I know that this is supposed to be a simple task, but my brain has fallen asleep on me.

I've created a combo box on a data entry form based on a table with 2 column (code,desc)

On the form, the desc is displayed but the code is stored in the underlying table.

When displaying the info., I would like to display the desc instead of the code.

How can I do this?

thanks

WS

 

[boblarson]

On the form, the desc is displayed but the code is stored in the underlying table.

As it should.

When displaying the info., I would like to display the desc instead of the code.

You just said it did display the description. You don't want to store the description as that would be a no, no when talking normalized, relational database. You can always pull everything back together in a query as people should not be viewing the tables directly, but in forms (in forms, in forms, in forms...you're getting sleepy, sleepy... )