I'm sorry to post this again - but I am still stuck on this one.
I will post the question again a little differently, and perhaps someone can tell me if CodeMine can do this in the native Find Dialog or not.
If I have an index on two fields like either of the two following:
INDEX ON UPPER(LAST)+" "+UPPER(FIRST) TAG LASTFIRST
or
INDEX ON TRIM(UPPER(LAST))+" "+TRIM(UPPER(FIRST))TAG LASTFIRST
and on a From CTRL+F to bring up the Find Dialog, this index will appear in the drop down as Lastfirst - which is expected.
I have 2 problems:
1-if I type in anything other than the Last Name - it will give a message that it could not be found - but I know it is in the table.
2-if I press List All, only the last name appears - and I would like both fields to appear.
Do I need to just write my own Find dialog to do this? or should CodeMine be able to handle this?
Any help is appreciated.
Mel Cummings