HomeApplicationOffice information

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
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 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
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 Picture 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 Picture 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 Picture 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 Picture 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 Picture 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

5 ★ | 1 Vote
relationship between tablesaccess2016

You should read it

May be interested

  • MS Access 2003 - Lesson 39: Analyzing tablesMS Access 2003 - Lesson 39: Analyzing tables
    access 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 tableMS Access 2003 - Lesson 15: Create an initial table
    in 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 2016Work with data in Access 2016
    in 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 tableMS Access 2003 - Lesson 12: Working with a table
    you 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 complexCreate data queries in Access 2016 from simple to complex
    the 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 RelationshipHow to Slow Down a Relationship
    sometimes, 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 AccessHow to Link Tables in Access
    microsoft 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 tableMS Access 2003 - Lesson 8: Change information in the table
    in 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 BetterHow to Make a Relationship Better
    after 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 MongoDBAdvantages of MongoDB
    any 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.

Office information