Hi,
So I'm looking to make a book collection database to catalogue my books. Nothing fancy, just books, their authors, and some minor details.
So far I have two tables:
Books:-Title
-Author
-Translator
-Editor
-Pages
-Copies
Authors:
-Author (Primary Key)
-Author Title
-First Name
-Last Name
There is a one-to-many relationship with referential integrity from Authors.Author --- Books.Author
So just to clarify, I know absolutely nothing about writing code or macros or anything like that. The most I've done is play around a bit.
I'm hoping to be able to input my books, and sort them by author. I have a form that has the Books table as a subform, with an unbound combobox that selects the different records (authors) from the Authors table. The Link Master is Authors.Author and the Link Child is Books.Author
What I'm trying to do is have a combobox at the top of the form that allows me to input new authors when I need to and then input the book underneath, and when I want to choose a different author, I can select from the drop-down list in the combobox and the record will move to that selection, showing me the books for the selected author. Being able to also edit authors would also be convenient.
I did this once with an attendance database, but that was a while ago and I forgot everything
Other issues I'm having is regarding updating the form to show new authors and their records in the combobox. I know that it requires some programming (I've been googling) to requery or something like that.
Any help would be much appreciated. I've tried to attach my db but it's over 1 mb in size and won't let me.