Primary keys for Users

[mav]

I wasn't sure how to define the subject for this one . . .

I have created a database with primary and foreign keys using text fields that the users would understand, so they can track and re-assign the records, via a alpha-numeric code that means something to them. I have also included a unique number field.

The users regularly need to re-assign the records, which they can do by changing the foreign key for that record.

The GTRR works fine for navigating with the user text field keys, but searching needs to be via the unique key.

As an example, the User Key is AN1 and the unique key is 00100 for this record.

Searching the unique field for 00001 only returns this record, but searching the user text field for AN1 also returns AN10, AN11, AN12, and so on, including AN100, AN101, if you see the pattern.

I can script the searching to just the unique field for isolating records for printing, and user will work out what has happened if they manually search the user text field.

Is there a better way and if not, what ‘other’ issues further down the road would this method create ?

Thanks in advance . . .

[aaa]

Hi, mav! You can tell to your users in find mode put

==AN1 instead AN1 and will searc only AN1