How would I go and do this? I have 1 solution but wanted some hints/check if I am on right path
To have two fields: Id, RefId... Id will be autonumber, in the form using macro/VBA (or even manually) I could copy ID value into RefId appending a letter in front?
To have two fields: Id, RefId... Id will be autonumber, in the form using macro/VBA (or even manually) I could copy ID value into RefId appending a letter in front?