>Suppose you have a dropdown combo showing a person's FULLNAME i.e. Don Freeman. We want the return value to be the person's ID number i.e. PERSON_ID. And we want the incremental search to be based on the LAST_NAME. This code gets me partway, but what else do I need to cause the incremental search to follow the last_name rather than the fullname?
>
>
>this.rowsource = "select fullname, person_id from people order by last_name into cursor " + this.name
>this.boundcolumn = 2
>this.incrementalsearch = .t.
>
>
>Is this even possible?
I think the combobox will always apply the incremental search to the first column. You can only pick what goes into first column. Maybe
this.rowsource = "select last_name-(", "+first_name), person_id from people order by last_name into cursor " + this.name
can do the trick.