Hi, I’m investigating an application to help schedule entertainers across multiple venues. I want the entertainers to be able to interact with the “base” only on records where they are assigned as an entertainer on specific events and not to be able to see/edit the entire base. Does that make sense?
The table would have the fields
- Job Completed (check box)
Records would be:
Date Event Venue Characters Job Completed
3/1/2019 Birthday Party Golden Arches Road Runner, Bugs Bunny (unchecked)
3/5/2019 Wedding Hidden Garden Foghorn Leghorn (unchecked)
What I want is a way for Road Runner and Bugs Bunny to be able to see and check the “Job Completed” field, but not ever see Foghorn Leghorn’s Wedding event, and vice versa.