Is this possible
I am pretty proficient with web design.
I have a client that has about 1600 drivers. He wants to conduct a bid every six months based upon seniority.
The bid would allow the drivers to choose the following:
The two days they want off.
The shift they want to work (which are numbered from 10-60) on the days they choose to work.
The ability to choose which vehicle they want to drive for the day.
A close example of this would be:
Employee Number 1 wants to work M-F from 7 am to 5 pm (shift number 30) driving vehicle number 8000.
Employee Number 2 wants to work M-F from 7 am to 5 pm (shift number 30) driving vehicle number 8001.-----However, Employee Number 1 took the only shift with the number 30, so there are no more 7-5's available Monday through Friday.
Would Filemaker allow me to create a database of drivers, shifts, days off and vehicle numbers which could be accessed from a webpage which could be automatically updated each time a driver chooses a shift-----which would make the shift unavailable for the remaining drivers.
I have plenty of website experience, just not database and my sql experience.