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.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |