>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.