I would like to be able too query, for example:
What route does employee A have Tuesday the week of 5/8/17?
Who is doing route CF/CDI on Friday the week of 5/15/17?
About how many hours would this take to set up?
Mark A.100% (2)
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
Hello, so it seems that master table A and B provided in the spreadsheet are just transposed data from each other and then you have the schedule table. The questions I have are
1. I am guessing you need CRUD screens for managing the routes and employees with slots etc. Is that correct?
2. Do you need historical data? What I mean by that is say you change the schedule for some one for Tuesdays from 05/15 onward. In that case, reports for period before 05/15 will need to reflect that old schedule OR then just always the latest data and hence current route schedule?
If you can let me know about these two, I will be able to make an informed bid.
Thanks.Mark A.10 May 2017
Table A and B are effectively the same thing in different format - not transposed exactly. I included both if it makes the task simpler, but only one is necesary.
1. Ultimately I will need a front end with CRUD. Initially I am just asking to put this into sql schematic form from a manual table.
2. If I read you correctly, I would need historical data.