Viewing related records only

[PollyU]

I have two tables linked by two relationships. What is the best way to view the linked child records only, can they be marked, filtered out? Thanks
Polly

[Ken]

Hi Polly,

Let's say you have your relationship set up and you have your parent table tiled on top and your child table tiled on the bottom. If you then toggle the "Filter related records" icon (or Tools > Filter Related Records) you'll see only the related child records listed in the child table.

To copy these out to a new table, simply select the child table and go to File > Save As to save the filtered set as a new table. If you want to mark records within the child set, you can do this too. When you remove the "Filter related records" toggle and just see the entire table again, the marks will remain as you set them.

Hope that helps -- let us know if you need anything further.

All the best,
ken