I want to use a combo list box to display info from table A and save the selection to table B based on the following:

Table A fields - number, description
Table B - store number

However, on the form, I only want to display the description in the combo box, and also allow users to do incremental searches based on description [not the number]. Right now, the combo box allows users to select based on description, but it displays the number for that description. It also only allows incremental searches on the number.

Any ideas on how to accomplish this?