Hi.
I’m trying to relate two simple tables. My first table is called, Books_Info_tbl which contains fields like: The title of the book, The released date for each book, number of chapters, number of pages, etc. Also, this table has a Primary Key, BksID & a Foreign Key from another table, ArthrID
The one essential detail which I excluded in the Books_Info_tbl is the author which I hope to keep in a separate table. Reason being, a lot of the books I read are by the same author. Therefore, my Authors_tbl has only 2-fields, ArthrID (set as the Primary Key) & author.
Now, when I set up these 2-tables, in the Relationship window I was not able to join the ArthrID from the Authors_tbl to the books_Info_tbl a one-to-many relationship. One author to many books. Makes sense to me. However, it doesn’t work because when I click onto Enforce Referential Integrity rule I received this error message shown below.(I mean attached) I don’t understand what it is that I’m doing wrong? I also attached the database for those who care to view it.
Any advice/suggestions would be greatly appreciated! Thanks in advance!