Share
Reporti have three tables: Trips (custom), Participants (custom) and Contacts (out of the box). Each Trip can have multiple associated contacts, and each contact can have multiple associated trips. There is an N:N relationship between the two tables.
Participants are assigned a trip and a contact. Each participant appears only once. There is an N:1 relationship between participants and trip and contact respectively.
On a power page I have two lists. One shows the trips and the other shows the participants. Table permissions are set as 'contact access', with the relationship between contacts and participants being used and the N:N relationship between contacts and trips, only for authenticated users.
When I log in as a contact that has been associated with several trips and also been added as a contact for several participants, I expect to see only 'my' participants in the participant list and 'my' trips in the trip list. For the participant list this works as expected.
For the trip list, I get the general error "We're sorry, but something went wrong. Please try again, and if this persists, contact the website administrator."
I figure this must be because of the N:N relationship, but can't figure out how to configure it to make it work.
Any ideas?
All responses (
Answers (
22
