Clear, practical technology insights BSOD Code Lookup · Windows Error Code Lookup · Wi-Fi Troubleshooting · PC Troubleshooting Checklist
TipsMake

1-n Relationship Between Tables in Access

Understand 1-n Relationship Between Tables in Access with clear background, essential details, and practical takeaways.

Table of Contents

This updated guide examines 1-n Relationship Between Tables in Access and organizes the essential facts, background, and practical takeaways in clear American English.

To establish a 1-n relationship, you do the same as a 1-1 relationship.

1-n Relationship Between Tables in Access — contextual image 1
Steps to create Relationships similar to 1-1 relationship

First, delete the old relationship by clicking the Clear Layout option on the Design tab .

1-n Relationship Between Tables in Access — contextual image 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 — contextual image 3
Adding new tables There are fields as shown in the image

Save the table as tblCongviec and go to Relationship in the Design tab .

1-n Relationship Between Tables in Access — contextual image 4
Return to Relationship after Clear Layout as above step

Click the Show Table option to display the dialog box.

1-n Relationship Between Tables in Access — contextual image 5
The Show Table dialog box appears

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 — contextual image 6
Both tblDuAn and tblCongviec tables are added to the screen

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 — contextual image 7
Drag the two DuAnID fields of the two tables together to display the Edit Relationships dialog box

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 — contextual image 8
Two tables after establishing a relationship will show up like this

Previous article: 1-1 relationship between tables in ACCESS

Next lesson: 1-n relationship between tables in ACCESS

FAQ

What is 1-n Relationship Between Tables in Access about?

It provides a structured overview of 1-n relationship, explains the main context, and highlights practical takeaways for readers.

Why does this topic matter?

Understanding the main concepts helps readers evaluate the issue, avoid common mistakes, and make better-informed decisions.

How should readers use this information?

Use the guidance as a practical starting point, confirm details that may have changed, and follow current product, safety, or security recommendations.

Discussion

Reader Comments 0

Sign in with email or Google to join the discussion.

Relationship Nn: Relationships Between Tables in AccessRelationship Nn: Relationships Between Tables in Access4 minutes readEstablish Relationships Between Tables in Access 2016Establish Relationships Between Tables in Access 20163 minutes readStandardize Databases in Access -- Relationships Between TablesStandardize Databases in Access -- Relationships Between Tables5 minutes readRelationship 1-1: 1-1 Relationship Between Tables in AccessRelationship 1-1: 1-1 Relationship Between Tables in Access3 minutes readMS Access 2007 - Lesson 8: Establish Relationships Between TablesMS Access 2007 - Lesson 8: Establish Relationships Between Tables3 minutes readSteps to Create Relationships Between Multiple Tables UsingSteps to Create Relationships Between Multiple Tables Using9 minutes read