Have you considered simply using Microsoft Project?

Job (order no, etc) = Activity or task with some log notes in user
fields
Resources can be assign to activities and time-phased (e.g. 50% over
time or 100 hour for that task.) The timephasing can reported be
weekly, month, etc.

Then you could export to your second data base.