AnsweredAssumed Answered

Relationship help (insert joke here!)

Question asked by weedonpaul on Nov 6, 2015
Latest reply on Nov 6, 2015 by Mike_Mitchell

Not sure how to explain this but here I go...

 

I have and events layout and table, in it I want to schedule meetings. I have a table called meetings and a table called contacts.

the relationship is events::kp_event_id= meetings::kf_event_id and meetings::kf_contact_id = Contact::kp_contact_id

 

within the layout "events" i have a portal to the meetings table.

 

the problem that I can't get my head around is that i want to link to two contacts within the meeting some one is meeting someone else both of whom are in the contacts table. when I add a phone number into the portal shoes phone number will appear?

 

any ideas?

Outcomes