AnsweredAssumed Answered

Issue with Join Table Relationships

Question asked by RPeters on Jun 21, 2016
Latest reply on Jun 30, 2016 by RPeters

Hi Everyone,


I'm having some trouble with my table relationships.  I work for a non-profit music festival and I have patrons attending events.


Here's my current set up, and it works great:


Patrons ----|| Income ||---- Events


So I can have patrons attending multiple events, and each event has multiple patrons.  This set up has worked really well for me so far.  I can use portals to display the information, and it's perfect!


But now I need to add another element to it, and I'm having some trouble.


One patron will be running each event, and I need to indicate which patron is in charge on each event page. (One patron can run multiple events.)  The tables are already related, and I just can't figure out how to differentiate a patron who is in charge of an event, versus a patron who is just attending an event as a paid customer.  The relationship that I need is this:


Patrons ----|| Events

but of course I already have a join table that eliminated that direct relationship.


I'm feeling quite stuck, and any advice would be soooo greatly appreciated!