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

Date

 

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!

 

Thanks

Outcomes