AnsweredAssumed Answered

Many to Many Relationship?

Question asked by raphthepenguin on Feb 6, 2014
Latest reply on Feb 12, 2014 by raphthepenguin

Hey there,


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

Attendance EventName



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!