Jump to content
Science Forums

Trouble With Microsoft Access


Recommended Posts

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...