Can't seem to view other tables data after running query (1 Viewer)

[ro801]

Hi, hope someone can help on this.
I have 3 tables; demographics, clinic1 and clinic2. If i just open the table i can view all the clinics associated with different patients (with a little + sign in the left)
However if i query the same table and enter a criteria that prompts for a hospital number (the primary key), i get all the data from the demographics table, but none from the other clinic's tables (no + sign ).
I suppose i could add fields from the other tables but i really like the drop down format representing each individual clinic the patient was enrolled in. Is there any way i can get this query to present the data like this?
Many Thanks

 

[VilaRestal]

If you go into the design of the query and show the properties on the right (right click in the grey space and select properties if it's not already visible) - there is a property called Subdatasheet Name. Select the table you want as the subdatasheet there.

 

[ro801]

Oh cool, can i add all available tables?

 

[VilaRestal]

yeah but if it's not related to the existing table then it will show all records for every record (if you see what I mean).