>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?
With Thisform.Combo
.Rowsourcetype=6
.Rowsource="tableA.description.number"
.Controlsoucre="tableB.number"
.BoundColumn=2
Endwith
Edward Pikman
Independent Consultant