Auto update time from previous record MS Access Form

[nandu05]

I have a form and i need to recordzthe daily job will be done for each items. my data will look as below:

Date	Item	Job	Time In	Time Out
06/11/2013	Item1	Job1	10:00	11:10
06/11/2013	Item1	Job2	11:10	12:00
06/11/2013	Item1	Job3	12:00	12:30

06/11/2013

Item1

Job4

12:30

02:00

and so on..

I would like to have the Job2 In time to be updated automatically as soon as I enter the Job1 Time out data
Appreciate if any one can help me in this regard.

[Dal Jeanis]

1) Are the daily jobs the same each day?
2) Are the jobs to be done in a predetermined order, an order that the program can know?
3) Is there a table storing the job data?
4) Is the job data created in advance, or should it be created as jobs are started?
5) What are you going to do with the data?