I have a database with numerous tables. Each table will be populated with auction items under the table name, eg paintings will be in the “Art” table, Childrens items will be in "Children"s Table , ETC.
I want to have auto number assign a number to each item as they are entered into the database.
How do I get each table to have a unique number or letter assigned to each table?
Foe example A1 could be Art, C1 For Children’s etc.