1-n relationship between tables in Access
The relation 1-n is the most common type of relationship. In this relationship, a record in the table may have multiple matching records in another table, but a record in the second table only has one matching record in the first table.
To establish a 1-n relationship, you do the same as a 1-1 relationship.
![1-n relationship between tables in Access Picture 1](https://tipsmake.com/data/images/1n-relationship-between-tables-in-access-picture-1-MTGZ5jPxh.jpg)
First, delete the old relationship by clicking the Clear Layout option on the Design tab .
1-n relationship between tables in Access Picture 2
Now you add a table about the work of each project including CongviecID, DuAnID, TenCongviec, DoUutien, TinhTrang, MoTa, RightBatdau, Hanchot, File :
![1-n relationship between tables in Access Picture 3](https://tipsmake.com/data/images/1n-relationship-between-tables-in-access-picture-3-9fcZRNj7h.jpg)
Save the table as tblCongviec and go to Relationship in the Design tab .
![1-n relationship between tables in Access Picture 4](https://tipsmake.com/data/images/1n-relationship-between-tables-in-access-picture-4-tMVcpEJfz.jpg)
Click the Show Table option to display the dialog box.
![1-n relationship between tables in Access Picture 5](https://tipsmake.com/data/images/1n-relationship-between-tables-in-access-picture-5-TUX0Tsgm9.jpg)
Select the tblDuAn and tblCongviec tables , click Add to add both tables to the desktop and close the Show Table dialog box .
![1-n relationship between tables in Access Picture 6](https://tipsmake.com/data/images/1n-relationship-between-tables-in-access-picture-6-kdRmdWp2D.jpg)
To create a relationship between these two tables, use the mouse to click and hold the DuAnID field in the tblDuAn table , drag to the DuAnID field you want to connect to the tblCongviec table . When you release the mouse, Access will open the following window:
![1-n relationship between tables in Access Picture 7](https://tipsmake.com/data/images/1n-relationship-between-tables-in-access-picture-7-2cBaweVyt.jpg)
Click on the Create button and now these two tables are connected, establishing a relationship with each other.
![1-n relationship between tables in Access Picture 8](https://tipsmake.com/data/images/1n-relationship-between-tables-in-access-picture-8-p8zPRjDH3.jpg)
Previous article: 1-1 relationship between tables in ACCESS
Next lesson: 1-n relationship between tables in ACCESS
You should read it
- Relationships between tables in Access
- 1-1 relationship between tables in ACCESS
- Standardize databases in Access - Relationships between tables
- Establish relationships between tables in Access 2016
- MS Access 2007 - Lesson 8: Establish relationships between tables
- How to change relationships on Facebook
- Steps to create relationships between multiple tables using Data Model in Excel
- How to Slow Down a Relationship
- 8 signs of your relationship will not go anywhere
- How to Make a Relationship Better
- Relationship in MongoDB
- How to give up a malicious relationship and love yourself more?