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!