I have a combo box (actually dropdown list (style=2)) listing different types of software to choose from. I populate this dropdown using rowsourcetype=SQL Select and rowsource="SELECT desc FROM software INTO CURSOR query".

I want to populate another table (CALLS.DBF) with the value of the selection so I set the controlsource to "calls.softwaredesc".

I would like to use this dropdown to serve the dual function of showing what was previously entered, and allowing the user to change the value of what was previously entered. My problem is that is a record that was previously entered has a softwaredesc that is no longer in the software table, it will not show as the value in the dropdown list.

Does anyone have any simple workarounds?