All sensitive data has been removed.
Currently this is used to track multiple jobs over different projects (the gannt chart is updated from this).
I would encourage criticism, but I am aware there are a LOT of issues, that's one of the reasons I've been reluctant to post the database. Feel free to give feedback, any thoughts or ideas are welcome.
I'm just posting it as a reference for now, but as I said any comments appreciated.
*Its currently used to track work days on jobs,
*it automatically tracks date changes to jobs (this needs to be changed to workdays)
*it will work out the amount of working days notice for these date changes.
I'm planning on adding more functions. Being able to generate better reports is what I'll be working on once I've polished off the tracking ability.
It has other basic functions such as adding additional costs manually to jobs.
As a general overview that's about it.
Test_DB.zip
Note: I'm currently changing the way jobs are added, you go to the site list first and select or create the site.. then create a job.
the create a job form will show any active and completed jobs.