Please can I request a system change so that users are able to insert a Primary Key field for each entry in a collection if they want the collection to use a Primary Key mechanism?
I basically need a Primary Key field which will hold a unique value per entry I insert.
Each time a new entry is entered into a collection the system will hopefully be able to automatically fill in the unique field.
If users would be able to set the pattern of the Primary Key, that would be fantastic.
For example per entry that I create in my collection, the Primary Key field would automatically insert something like:
And where the Alphabetic Characters appear at the front maybe this could be changeable in the Options menu so users can change it to what they would like.
For example in the Options menu you would have something like:-
To set a Primary Key please specify a character pattern that would pre-fix each Key : “………………”
Each Primary Key will use this character pattern immediately followed by numeric characters :
i.e. 01, 02, 03 ………