Reporting on relational data

[thevix]

Hi,

I am new to Filemaker so I don't even know if this is possible....

I have created my tables with relationships. [Child], [Activity] [Attainment]. [Attainment] contains the primary keys from [CHild] and [Activity] and the related outcomes.

So in this table there are multiple records with the same Child_Id.

I would like to produce a report/layout which shows all these records in a list, given a certain Child_Id.

I understand how to get this information i.e. the query but don't know how to view it in a layout

 

[thevix]

ok never mind - sorry for the post - i figured it out