This example shows Wilma Flintstone rescued using the Bell 206. It took 23.5 hours over two days. John Smith was both Medic and Winch Operator. At $1,000.00 per hour for this aircraft, the reimbursable cost of the operation was $23,500.00. You can see in the Employee Crew Activity Log the drop-down selection combobox control that allows you to select any employee. You can then either input Flight Activity OR if it has already been used, you can select one using the drop-down. Each Activity Log is linked to each helicopter and each flight operation. If you select a different helicopter or different flight operation, these fields will change to reflect the data for only that helicopter and/or flight operation.
This is very preliminary. I don't know what every field means or if they are even needed. I just took what was indicated in the original post and used those fields. If this very preliminary design works for you, I can attach it and you can have it. I created no reports or other queries. But if you can present it on a form, then you can present it on a report also.
This form consists of a series of subforms which are linked to parent forms. Some are single forms and some are continious. I use continious forms if there is going to be many entries for any one parent record. In this case, each helicopter and each flight operation may have many crew activities, so continious forms are convienent.