>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?
The other solutions work great. If you don't want to display the number use the builder layout tab (I can't remember exactly so if it is another tab don't get mad) to reduce the with of the second column (in this case number ) to nothing. It will show as a slightly bold vertical line on the right edge in the drop down . The tab you are looking for displays sample data in a browse style. Just click and drag the right edge of the to the left edge.

Terry