1-n relationship between tables in Access
The 1-n relationship is the type of relationship in which 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.
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.
First, delete the old relationship by clicking the Clear Layout option on the Design tab .
Now you add a table about the work of each project including CongviecID, DuAnID, TenCongviec, DoUutien, TinhTrang, MoTa, RightBatdau, Hanchot, File :
Save the table as tblCongviec and go to Relationship in the Design tab .
Click the Show Table option to display the dialog box.
Select the tblDuAn and tblCongviec tables , click Add to add both tables to the desktop and close the Show Table dialog box .
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:
Click on the Create button and now these two tables are connected, establishing a relationship with each other.
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?
Maybe you are interested
Create Autotext in Word 2007, edit documents faster Alignment in Word 2010, beautiful alignment of Word 2010 documents How to master numerical data in Google Sheets with the AVERAGE function How to change commas to dots in Word - Number unit separator How to Justify Text in Cells on Excel - Adjust Text Spacing How to strikethrough text in Word, write strikethrough text in Word and Excel