LOOKUP() is getting locked into a loop resulting in error

I’m getting a looping error from my LOOKUP() …

In a Security Filter for the “Attendees” table i have the following:
[Study]=LOOKUP( USEREMAIL(), “Studies”, “POC Email”, “key” )

Error that im getting back
Error: Data table ‘Attendees’ is not accessible due to: Error: Data table ‘Studies’ is not accessible due to: Error: Data table ‘Attendees’ is not accessible due to: Error: Data table ‘Studies’ is not accessible due to: Error: Data table ‘Attendees’ is not accessible due to: Error: Data table ‘Studies’ is not accessible due to: Error: Data table ‘Attendees’ is not accessible due to: Error: Data table ‘Studies’ is not accessible due to: Error: Data table

Table Structure
Studies: key, Study, POC (ref to Attendees), POC Email ([POC].[Email])
Attendees: key, Name, Email, Study (ref to study attended)

You can clearly see where the loop is.

Goal
I would like to be able to assign the POC from the list of name in the Attendees list.
I need to pull up a view of ONLY the Attendees in the Study that you are POC for.

0 1 297
1 REPLY 1
Top Labels in this Space