1-1 relationship between tables in ACCESS
1-1 relations are used to link a record from one table to one and only one record in another table.
One-to-one relationships are created when both connection fields are primary keys or have unique constraints.
For further clarification, continue with the database and the tables we created in the previous lesson. First, go to the Database Tools tab.

Click on Relationships option .

Select the Members panel and tblHRData, click Add to add both tables to the working screen and then close the Show Table dialog box .

To create a relationship between these two tables, use the mouse to click and hold the NhanvienID field in the tblNhanvien table , drag the connection to the field you want to connect to in table tblHRData. When you release the mouse, Access will open the following window:

This window relates to the tblNhanvien 's NhanvienID and NhanvienID of tblHRData. Click on the Create button and now these two tables are connected, establishing a relationship with each other.

This relationship is automatically saved by Access without saving . Recently we have created the most basic relationship, next, choose each table to see if there is anything different from the beginning.
You open the table tblNhanvien.

Normally on the left side of each record, you will see a small plus sign by default. When creating a relationship, Access automatically adds a child datasheet to the table.

Click the plus sign and you will see information related to the records available on the tblHRData table .

Click on the Save icon and open tblHRData, you will see the entered data already here.

Previous article: Establish relationships between tables in Access 2016
Next lesson: 1-n relationship between tables in ACCESS
You should read it
- Standardize databases in Access - Relationships between tables
- 1-n relationship between tables in Access
- MS Access 2007 - Lesson 8: Establish relationships between tables
- Steps to create relationships between multiple tables using Data Model in Excel
- Advantages of MongoDB
- How to change relationships on Facebook
- 14 questions you need to answer before starting a new relationship
- 8 signs of your relationship will not go anywhere
May be interested
- MS Access 2003 - Lesson 39: Analyzing tablesaccess includes a very powerful tool that you can use to analyze data in one or more tables.
- MS Access 2003 - Lesson 15: Create an initial tablein this section, you are ready to create a table for the new database. in chapter 2, you used the table wizard to create tables easily. this not only shows that creating a table manually is difficult; but it is a sure way to understand the table.
- Work with data in Access 2016in the previous lesson, you became familiar with the access 2016 interface as well as the opening and closing of the basic database. this article will continue to go deeper into access 2016 around the content of working with data in access 2016.
- MS Access 2003 - Lesson 12: Working with a tableyou have learned how to create and design tables in access. and now it's time to learn how to manipulate all tables.
- Create data queries in Access 2016 from simple to complexthe query allows to retrieve information from one or more tables based on the search conditions you defined. in this lesson, you will learn how to create queries on a simple table and query on multiple tables in access 2016.
- How to Slow Down a Relationshipsometimes, you might feel like a relationship is moving too quickly – whether that means physically or emotionally. it's important to remember that a relationship is an agreement between two people. you don't need to go along with...
- How to Link Tables in Accessmicrosoft access allows tables and databases to connect with each other. this capability can increase your efficiency and easily spread information that is required for multiple departments or reports. you can make changes in the original...
- MS Access 2003 - Lesson 8: Change information in the tablein the previous section, you learned how to use the datasheet view mode to enter information for the table. the datasheet view mode also allows you to edit available information quickly and easily.
- How to Make a Relationship Betterafter all the effort it takes to get into a quality relationship, it may seem like the hard work is over once you start dating someone. however, a healthy relationship is like a living, breathing thing — it takes constant care and...
- Advantages of MongoDBany relation database has a unique schema design to index the data tables and relationships between those tables. meanwhile in mongodb there is no concept of relationship.