Subform only shows first match

[collizz]

It's been a while since I last used Access but now I need to be reminded how to populate a sub-form with all rows for a query (Access 2013).
Can someone please let me know:
- Do I need to establish a relationship between Table A (main form) and Table B (sub-form)?
- What sub-form properties need to be set to display all retrieived rows from the main form query (select where Table A PK = Table B PK)?
Thanks

 

[Dewi]

In database tools, relationships...build a link between your main table and sub table. For every one record in Main Table you may have many records in sub table. Draw the link to show a one to many, right click the joint and edit relationship to show "include all from Main table and only those from subtable with matching records" or something like that .

Pick a unique key in MainTable as your identifier, I use an Autonumber as a primary key. In your sub table call a field "LinkToMain".

In the subform, properties, data there are two rows called "link master Field" and "Link Child Field". set these u as your ID and LinktoMain fields.

Cheers