My second thought was to assign dates to rows (records) on a table, then somehow link a pilot from the pilot table to the schedule table field that matched his ID. My original thought was that I could have a table that assigns dates to fields however, Access limits the number of fields to 255 (obviously 365 days in a year so that won't work). The biggest problem I have right now is that I don't know what the best way is to schedule a pilot to a day (or rotation of days) of work. I have a table of all the pilots that work for our company and I have a table that I've been trying to use to create a schedule for each individual pilot. I'm trying to use MS Access to develop a pilot database/scheduling system. I'm a crew scheduler at a private aviation company with over 170 pilots. This is my first post so forgive me if I confuse anyone (feel free to put me on blast).
