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!

 

Thanks!

-Rachael

Outcomes