Am I able to change a One-to-Many Relationship to a One-to-One Relationship when using Access?

Kaitlin Mix 1 Reputation point

I am wonder if it is possible to change a one to many relationship to a one to one relationship when using access. My access automatically says the relationship I am trying to create is a one-to-many. However I need it to be a One-to-One relationship, is this possible?


Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
842 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Gustav 712 Reputation points MVP

    Yes. Go to menu Tools and click Relations in the ribbon.
    The relations will be displayed.
    Double-click the relation you wish to modify, adjust as needed, and click OK.

    0 comments No comments

  2. Ken Sheridan 2,751 Reputation points

    A one-to-one relationship type is defined by the foreign key of the referencing table in the relationship also being a primary key, though not an autonumber of course, or otherwise indexed uniquely. For examples see in my public databases folder at:!169

    0 comments No comments