>>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?
>
>Hi
>
>See my download #23713

Thanks Dorin. This is a bit more complex than what I wanted but I will keep it for future reference.

- Don