OK, think as to how entities are related.
An author writes several books.
Each book can fall into a particular category.
Each book might have more than one author?
Break it down until YOU know what you want out of the DB. That generally defines what you need to store.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Here's a possible starter for you:
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Glad it is of interest to you. I'm also busy today with family, but if I can be of any further help, post back and I will respond asap
PS
Enjoy the rest of the festive break.
Last edited by Bob Fitz; 12-27-2023 at 12:04 AM.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick