Allow access based on a calculation within a portal's records

[Slater]

Hi All,

 

I've got two records. The parent record has a 1 to many relationship with the child.

 

The parent is for clients

The child is for people

 

I want to only allow someone access to the parent records, when there is at least one child records which has Are_They_Green = "Yes"

 

So if any of the client's people are green, then access will be allowed to the parent.

 

I'm using a calculation within the privilege set, view limited: Are_They_Green = "Yes"

 

The problem that i've got, it seems to me, is that i'm only getting one or a couple of layers down in the portal. How can i calculate it to show that there is at least one occurrence of Are_They_Green = "Yes" (assuming this is the best way to go).

 

Thanks for any help - been searching but to no avail!

 

 

 

 

[comment]

Try:

not IsEmpty ( FilterValues ( "Yes" ; List ( Child::Are_They_Green ) ) )

[Slater]

What a great suggestion - thank you so much. I'll be able to try it tomorrow.

Best wishes

[Slater]

Worked a treat - many thanks for your imagination and help!