Junction table in subform in Access 2007

[BrizzoRay]

INSTRUMENTAL-PART Table (e.g. Flute 1, Flute 2)
MUSICAL-PUBLICATION Table (including musical titles)
JUNCTION Table subordinate to both the other tables

The form displays the rows in a subform.
I need the subform rows to include musical titles from
The users would not be permitted to perform updates in the subform.

Hopefully this is possible in MS Access 2007

[June7]

You can join the JUNCTION and MUSICAL tables as the subform's recourdsource. JOINTYPE: 'Show all records from JUNCTION...'

This will make the title field available for display in the subform.