Others

Display Junction Table Projects in a Microsoft Access Subform

Huda QurayshiHuda Qurayshi Nov 20, 2026 868 views

Question details

Display all projects associated with the selected grant in an Access subform.

Display Junction Table Projects in a Microsoft Access Subform
Product
Microsoft Access
Device & OS
not provided
Scenario
A grants form needs to show project attributes through a junction table that supports a many-to-many relationship.
Observed behavior
The subform should show the projects linked to the current grant, with project attributes available for viewing.
Before you start

Confirm that Grants and Projects each have a primary key and that ProjectGrant contains the matching GrantID and ProjectID foreign keys. Use the actual table and field names in your database if they differ from these examples.

Solution 1Recommended

Link a project query to the grants form

Use a joined query and a linked subform to show the current grant’s projects and their attributes.

The junction table stores the grant-project relationships. A composite primary key on GrantID and ProjectID prevents the same pair from being entered more than once.

1
Check the junction table

Open ProjectGrant in Design View, select the GrantID and ProjectID rows, and click Primary Key if they are not already a composite key. Use Database Tools > Relationships to check that each field is related to its parent table.

2
Create the project query

Select Create > Query Design and add ProjectGrant and Projects. Join ProjectGrant.ProjectID to Projects.ProjectID, then add ProjectGrant.GrantID, ProjectGrant.ProjectID, and the project name, category, or other fields you want to display. Save the query.

3
Create the subform

Select Create > Form Wizard, choose the saved query as the source, and include the fields to display. Choose a tabular or datasheet layout and save the form.

4
Add and link the subform

Open the Grants form in Design View and add the saved form using the Subform/Subreport control. Select the subform control, open its Property Sheet, and set Link Master Fields to GrantID and Link Child Fields to GrantID.

5
Make it read-only and test

Open the subform in Design View and set Allow Edits, Allow Additions, and Allow Deletions to No in its Property Sheet. Open the Grants form in Form View and move between grants to verify that the subform shows the corresponding projects.

Link a project query to the grants form
GrantID must be available: The main form must have GrantID available in its record source, and the subform query must include ProjectGrant.GrantID so Access can link the records.
Free Microsoft Office alternative

Use WPS Office for Project and Grant Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with project and grant lists in spreadsheets. It supports common Office formats for an easier move between office suites, but it does not replace Microsoft Access forms or fix Access subform issues.

Organize project and grant lists in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar interface for everyday office tasksWork with documents and spreadsheets in one lightweight suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does the subform show projects from every grant?

In the Grants form’s Design View, select the subform control and check its Property Sheet. Set Link Master Fields and Link Child Fields to GrantID, and make sure GrantID is included in both record sources.

Why is the subform empty for a grant?

Check that ProjectGrant contains rows with the selected GrantID and that their ProjectID values match records in Projects. Open the saved query directly to verify that it returns those rows.

Can I use a combo box to select projects?

Yes. For an editable subform, add a combo box bound to ProjectGrant.ProjectID and use Projects as its row source. Enable additions or edits as needed; a read-only subform is intended only for viewing existing links.

Why use a composite primary key in the junction table?

A composite key on GrantID and ProjectID prevents duplicate grant-project pairs while allowing each grant to have multiple projects and each project to belong to multiple grants.