Relationships across three files?

[Jalz]

Hello All,

I've got a database, lets call it Master which has a portal displaying contents from the child database.Its a one to many relationship, which works great. However I now have the need to filter the data that s displayed in a portal, using multi critera this should be easy. The problem is the data I need to related to from the Master file in the grandchild table, which is incidentally linked to child. Is there anyway I can filter portal records based on two tables without having to duplicate the field in the child table (my nice structure would be seriously messed up)

I have posted a pic of a basic example of what I mean as I'm not very good with words. I'm trying to display names in a portal in my Master file, that have the value 15 in year which is stored in the grandchild - very basic anology.

Many Thanks for your help.

[bcooney]

It's actually more helpful if you use real data examples. Why would a record be "incidentally" related? Is your grandchild record's value that you wish to filter by a stored value?

[RalphL]

You need another relationship in you graph. Add a portal using this relationship. Also a global field Year in the child table. See Attached pdf.

Jalz.pdf

[preeves7001]

I am following this post and am slightly confused. I have a real world situation that I would like to throw out.

I have a book. This book can have multiple themes (Animals, Sports, etc...). A theme can have multiple sub-themes (Animals: Brave, Strong, Friendly, Fierce, etc..., Sports: Baseball, Soccer, Dog-sledding, etc...).

Thus a book about the Iditarod Dog Sled race using a portal for the theme and sub-theme could have Animals: Brave, Animals: Strong, Sports: Dog-sledding.

Thanks.