creation alpha numeric code

[Jen0dorf]

Hi

I have a Cemetery table with 39792 records each of which contains a field called Mlink which is not unique in fact I have 9994 different mlinks.

each mlink is short text and has the format of L,NorL,NNN

ie NN123
N1234
NN1234

Now when I create a new record is there a way to have access populate that field with an automatic number that is unique but allow an manual over type if required.

To elaborate if the family Jenkins has graves all family members will have the same Mlink ie NN1234

So if a new burial takes place of a jenkins family member they would need the Mlink NN1234

But if a new Burial takes place with no relative existing that would require a new Mlink that has not been used before

thanks

Ian

[ranman256]

Mlink = "NN" & format(date(),"yymmddhhnn")