Hello All,
So I have been given the task of tracking driver's paperwork and the trucks they are assign to. Here is my plan for the database.
DVIR's and Driver Logs pose a problem to me because they have individual dated but we group them by week ending dates. I am not sure how to handle that. The DVIR's have a relationship to trucks and drivers.
I need to report on trucks, their status, and if they are assigned or not.
I also need to be able to give warning to the office in advance of when a driver's med card or license is about to expire
Timesheets, DVIR's, and Driver logs have to be turned in once a week. I then have to scan them and send them to the office. Plus, I need to know what i received, missing, and also what I have returned and why. I also need to be able to print a driver roster for turn in showing the drivers and what they turned in.
Any help would be great before I start down this rabbit hole
ThanksAttachment 33230