Good afternoon all
I am creating my first Access database in over 20 years and I need a 'Job Number' field which is auto generated and the record is saved. This would be a combination of the Primary Key, which is an auto number, and a 3 character text field which is already in database.
I cannot find a way to do this, is it even possible?
Thanks in advance