Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Set Table Relationships in Access 2013
How to Run the Query Wizard in Access 2013
How to Create a Navigation Form in Access 2013

10 Things You Need to Know about Relationships in Access 2013

Step 10 of 10
Next Slideshow
Next Slideshow

If a primary key is part of a relationship, you can’t change the primary key in that table to another field without first deleting the relationship.

To change primary keys in a table where its primary key is part of a relationship, you must first open the Relationships window and delete the relationship before Access will allow you to change the primary key to another field in that table.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Start the Report Wizard in Access 2013
How to Import Data Sources in Access 2013
How to Filter Multiple Fields in Access 2013
Changing Form Controls with VBA in Access 2013
Getting Help with Functions in Access 2013
Advertisement

Inside Dummies.com