I have an Event App, I have three different Users, the first user is the general public which purchases the tickets, the second user is the Admin and the third user is the promoters. My problem is that I need to allow every promoter to create, delete, and edit their own events. Still, once I create an Event with one promoter all promoters can access it and edit or delete another promoter’s event.
You can create a relationship “Events” - “Users”, so that one User can have many Events, and each Event belong to one User. Give this relationship a proper name on both sides (e.g. My Promoters Events and User-Promoter).
Then you can filter these events by User-Promoter and allow/disallow editing.