i'm new to access, i am trying to create a relationship between two tables. I'm trying to Connect the primary key of Books (Book_Number) to the (Book_Number) in Borrowed_Books table.
it wont let me enforce referential integrity and i don't know why. i have all the same numbers so i don't really understand the popup that i am getting.
can anyone tell me what is wrong with the two fields that is not letting me create a relationship between them with referential integrity?
Library Database.accdb