I manage a non-profit: lots of volunteers, lots of events,
lots of activities, etc.
Basically I need a way to default every detail record to a specific Master without having to “select Master, select Master, select Master, etc.)
·We have multiple fund raising Events
· Each Event (Master Record) has Volunteers (Detail Records)
Each Volunteer (Detail Records) has multiple Activities (things to do)
Each Attendees (Detail Records) may have multiple Requests, to be acted upon.
How can I limit/control volunteer access to only the Detail Records (multiple related detail tables) of a specific Master Record (Event)?* Volunteers should only have access to the Detail Records of the Master Record(Event) they are assigned for the duration of the Event.
Copy Master Detail does not apply.