AnsweredAssumed Answered

Issue with Join Table Relationships

Question asked by disabled_RPeters on Jun 21, 2016
Latest reply on Jun 30, 2016 by disabled_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!