I am brand new to access and am trying to create a database to keep track of my personal possessions and collectibles so I can have a good sense of what I have and have a compete record for insurance in case something would happen.

What I am trying to do it have a master table in which every item is given a unique ID, and a series of qualities that every item will have (Name, item type, brand, condition, date of purchase, purchase price, etc.)

However, each type of item will also have information unique to that category. So books will have ISBN, author, number of pages, publisher, etc. Movies will have studio, runtime, rating, etc. So I intend to give each item type its own table.

What I want to do is set up the database so that when items are added it will automatically populate everything from their row in the master list to their corresponding columns on that specific type’s table.

For example, when I enter in a new book, and set the item type to “Books”, it will take all of that information from that row (ID, Name, brand, condition, date of purchase, etc.), and place it in the items table, where I can then input all of the information that is only tracked for books, but any universal information is tracked on both the books and the master list.

This would be set up for about 20 different types of items, all working in the same way as described above. Is this possible?