Connect multiple tables in Access

I want to connect multiple tables in Access. I have a main table and then multiple smaller tables that I would like to connect. Each row in the main table belongs to one entire sub-tab开发者_JS百科le. I would like to have small + appear next to each row in the main table and showing the sub-tables upon clicking on the +.

I tried this via relationships but it only works for the first row (perfectly) but not for any other rows. When clicking on the other rows, they are empty and no sub-table is opening up.

Any ideas?

To connect multiple tables in Microsoft Access, you can use the "Relationships" feature to define the relationships between the tables. This will allow you to create queries that combine data from multiple tables, as well as to enforce referential integrity between the tables.

Here are the steps you can follow to connect multiple tables in Access:

Open your Access database, and click on the "Database Tools" tab.

In the "Show/Hide" group, click on the "Relationships" button. This will open the "Relationships" window.

In the "Relationships" window, click on the "Add Table" button. This will open the "Show Table" dialog box.

In the "Show Table" dialog box, select the tables you want to connect, and click on the "Add" button. This will add the tables to the "Relationships" window.

In the "Relationships" window, drag the primary key field from one table and drop it onto the foreign key field in the other table. This will create a relationship between the tables.

Repeat the previous step for each pair of tables you want to connect.

When you are finished, click on the "Close" button in the "Relationships" window. This will save the relationships between the tables.

Once you have defined the relationships between the tables, you can create queries that combine data from multiple tables. To do this, simply select the tables you want to include in the query, and then drag and drop the fields you want to include in the query design grid. Access will automatically create the necessary joins between the tables based on the relationships you defined earlier.