I have an Access database with three tables. Each table has an auto number for identification.
I would like to add a prefix to the autonumber indicating which table it is. The prefix can be a simple single capital letter.
I would prefer that this is done in the original table and not a query.
Any suggestions?