ceccheer Posted April 16, 2017 Report Posted April 16, 2017 Hello, I am very new to creating databases and am taking a very basic computer science class at the moment. My task to create a small database of information on Microsoft access. I created two different tables and created a relationship between them using the primary key of one and foreign key of another; both have the same name and same values within their columns. The referential integrity has been enforced as well as the two boxes below that are checked. Despite all of this the relationship is not reflected when I go back to the tables. What may have caused this and what can I do to ensure the relationships between my tables are reflected in the datasheet view of the tables themselves? Thank you! Use simple language; as I said I'm incredibly new to this. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.