I have made a DB that as well as other things, manages the field works we carry out at work.
There are several job types that we do in the field. The jobs are created, and left unassigned to any engineer or without a scheduled date.
The jobs are then scheduled outside the system using mapping software etc, then they are assigned an engineer and date within the system, this then allows the worksheets to be printed and the jobs go on to be closed down when the engineer completes the job in the field.
At the moment when a job is assigned to an engineer and a date in the system, there's a form which opens, which as 2 list boxes on it and a combo box. One of the list boxes shows all the jobs that are waiting to be assigned, you then select the engineer from the combo box and the date this then populates the other list box which show what the selected engineer has assigned already for the date selected. If there is spare capacity for the day, then double click on the job waiting to be scheduled and it assigns it to the engineer and it disappears from the waiting list box and appears on the engineers list box.
What I could do with a little help with is.... Some of the jobs span multiple days, ie could be a 3c or 7 day job etc. How can I set this up so that when it is assigned to an engineer for say 01-01-2013 and it is a 3 day job, it shows when you check the engineer for 01-01-2013 & 02-01-2013 & 03-01-2013?
There is a table (tblFieldWorks) which holds the assigned field resource (which is a lookup to the tblFieldResource) and a scheduled date which is populated once the job has been scheduled.
Occasionally we also have some of the jobs which have two engineers assigned to them, if this could work across both engineers then that would be even better, but I am not that bothered about that at the moment as these are few and far between to be honest, but probably better to get it in from the start if possible.
If anyone has any idea's I'd love to hear them.
Thanks
There are several job types that we do in the field. The jobs are created, and left unassigned to any engineer or without a scheduled date.
The jobs are then scheduled outside the system using mapping software etc, then they are assigned an engineer and date within the system, this then allows the worksheets to be printed and the jobs go on to be closed down when the engineer completes the job in the field.
At the moment when a job is assigned to an engineer and a date in the system, there's a form which opens, which as 2 list boxes on it and a combo box. One of the list boxes shows all the jobs that are waiting to be assigned, you then select the engineer from the combo box and the date this then populates the other list box which show what the selected engineer has assigned already for the date selected. If there is spare capacity for the day, then double click on the job waiting to be scheduled and it assigns it to the engineer and it disappears from the waiting list box and appears on the engineers list box.
What I could do with a little help with is.... Some of the jobs span multiple days, ie could be a 3c or 7 day job etc. How can I set this up so that when it is assigned to an engineer for say 01-01-2013 and it is a 3 day job, it shows when you check the engineer for 01-01-2013 & 02-01-2013 & 03-01-2013?
There is a table (tblFieldWorks) which holds the assigned field resource (which is a lookup to the tblFieldResource) and a scheduled date which is populated once the job has been scheduled.
Occasionally we also have some of the jobs which have two engineers assigned to them, if this could work across both engineers then that would be even better, but I am not that bothered about that at the moment as these are few and far between to be honest, but probably better to get it in from the start if possible.
If anyone has any idea's I'd love to hear them.
Thanks
