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 294
1 REPLY 1

UPDATE:

by setting the Study POC and POC Email fields to static text (no reference) everything works as expected! with the exception that the POC and POC Email are now static fields.

Top Labels in this Space