Adding Unique automated numbers to old data

Hi Guys and ladies

I wrote a program years ago for a church and then did not know how to make surnames unique. The users have to enter a unique surname eg. Abrahams j, Abrahams R etc to make field unique. I finally found that I could use a record automated number as part of the sort key to make the surname unique.

Question. How can I use the old data from the old program to and make surname unique if there are no automated number on this data? Hope this is clear. Many Thanks

I don’t think surnames can be unique :slight_smile:

And for sure you just need at least one unique key by SysRef (ID) like a long type…

Then if you need to sort By surname you can just have a key like

and it will be unique

1 Like

Thank You sir/madame