Thank you for your post.
Yes, this is very feasible with FileMaker Pro. However, web design and databases are quite different.
The basic concept for your project would probably require a tables for:
When a driver selects a shift, vehicle, and vacations, the appropriate records would need to be updated so that other drivers won't be able to see them when they select their shift, vehicle, vacation, etc.
Can one vehicle be used on a different shift that doesn't overlap the first shift? That is, someone chooses M-F 7 to 5. If a person select M-F 8PM to Midnight, is that vehicle available? That is some of the logic you'll need to enter when you set this up.
Yes, this can also be made available via the web using FileMaker's built-in Instant Web Publishing.
Thanks for your post.
Knowing that it CAN be done goes a long way to helping me get started.
Yes, the vehicle will be used twice a day by two different shifts.
Since I've never dealt with databases per se, I can see a few fun frustrating weekends ahead of me.
Thanks for your input on the tables.
If I am understanding your explanation, I will need to find out how to make the database update via a command when a driver selects his new shift so that it removes the shift and vehicle from other drivers.
We will have two shifts so I can create two databases----one for days and one for nights.
You can have two different tables (one for nights and one for days), but it may be easier to put the shifts in one table. That way, when a car and shift is selected, that record is marked reserved (or to not show for subsequent searches), but the car would show up under a different shift. Does that make sense?