Is there a way to populate a combo box with both an ID's and Desciption and then have it strip the description when it to reads or saves the record?
For example, I have a table with Ids, 1, 2, 3, etc and descriptions Black, Red, Blue, etc.
On the combo drop down list I would like to see:
1 Black
2 Red
3 Blue
I can populate the combo list with the CREATE event, but I cannot read or write to the record, since the id would contain the added description field.
I guess I am looking for a MV combo list