AnsweredAssumed Answered

Is this possible

Question asked by b3enthusiast on Apr 16, 2009
Latest reply on Apr 20, 2009 by TSGal

Title

Is this possible

Post

Dear board,

 

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.

 

Thanks,

b3 

 

Outcomes