Miscrosoft Access can't create this relationshop and enforce referential integriry. Data in my tblMainBook violates refferentail integrity rules.
I have the MainBook table and 12 related tables (ie Status,Year, 3 Type fiield, library, media type, book Series, Reader, and Class) all of which are foreign keys in the table . The table has 5 other fields(notes, Time and 3 checkbooks). I've been able to set Ref Int on 4 of relationships but can't on the other 8; 4 are required fields for each audiobook, and 4 are optional.
The tells me to fix the problem in the MainBook table - can't find one since the are foreign keys. Help!
Scott Axton
@Reply 3 years ago
Double check that your data types match. An Id of AutoNumber in one table can't match to a foreign key of another table that is Short Text.
Robert StottOP
@Reply 3 years ago
I figured it out - I had some Foreign Key in the main book table data that didn't match Primary Key in each of the table. I did an unmatched Query to identify errors and to fix them. I database now has referential integrity for all tables.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 2.
