I am first timer with ms access and also here
I am working on a database of library. I have two different tables which stores details one for books and others for Periodicals.
How can make accession number primary key for both tables.
Are autonumber a accession number when a new entry made in books are periodicals.