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?