Combo Box view help

[mdgibbs88]

Hi All,

You have been a great help to this novice in the past, and I am again asking for some help.

I have 2 tables, the first is CASEDATA and the second CODES contains a list of codes. The CodeNumber is the joined field between the tables.

In my form, I have a Combo Box that lists the code and description from CODES, but when I select one of the codes the description disappears and I only see the CodeNumber, which is what is stored in the CASEDATA CODE field, but having an end user seeing a number 256 vs. Fraud Case in the field is less than user friendly.

How do I keep the description vs. the code in the field on my form without adding a text box next to the dropdown that has the description listed?

I hope this makes sense.

Thanks,
Mark

 

[rammudali]

hi
in the property of combo, select column count as 2 and column widths as 0";2"(desired width). this enable to add code to the table while display will be only description

enjoy

 

[mdgibbs88]

rammudali, That was exactly what I needed! Thank you so much!

Mark