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 e...