Display Junction Table Projects in a Microsoft Access Subform
Question details
Display all projects associated with the selected grant in an 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.
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.
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.
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.
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.
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.
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.
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.

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.

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.




