Kirix Support Forums

Viewing related records only

Please post any help questions, requests or other feedback here.

Viewing related records only

Postby PollyU on Fri Dec 18, 2009 6:23 am

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
PollyU
Registered User
 
Posts: 2
Joined: Fri Dec 18, 2009 6:20 am

Re: Viewing related records only

Postby Ken on Fri Dec 18, 2009 11:45 am

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
Ken Kaczmarek
Kirix Support Team
User avatar
Ken
Kirix Support Team
 
Posts: 147
Joined: Mon Dec 19, 2005 10:36 am

Return to Strata Help & Feedback