I am once again struggeling with relationships!
I have a Person Table and an Event Table.
The endgoal is have a portal List with ALL the Events are an I can easily mark attendence of the current viewed Person record.
On the flipside it would be great to have a List of all the People and I can mark attendence of the current viewed Event record.
Now I thought this would probably a Many to Many relationship and created a joined Tableoccurance PersonEvent.
So essentially its:
Person Table: PersonEvent Table: Event Table:
kp_Person = kf_Person
Name kf_Event X kp_Event
I hope till here at least things are correct.
Now I started with the portal. The problem is that Events are only shown when a person was there... But when I change it arround it shows attendence for all contacts!
I hope I clarified the problem and would appreaciate help!