I am a new member seeking assistance with a Microsoft Access solution for scheduling training events over an extended period, while managing a limited number of crew members and equipment. Each event will have specific requirements regarding the necessary crew and equipment. Upon receiving requests for future events, I need to ensure there are no conflicts, such as double bookings of assigned crew and equipment within the specified date range (from event start date to event end date). Given that each event requires multiple crew members and several pieces of equipment, it is essential to have the capability to assign more than one crew member and multiple pieces of equipment to each event.
Ideally, I would like to have a form that permits the selection of equipment and crew members for available date ranges, ensuring they are not already assigned to other events. Additionally, I would need to generate reports displaying events along with their assigned crew members and equipment in a calendar format.