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
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.