Relationship Need Help

[gregorytan]

Hi Sir

I have created two record for my stock use record, one call shift stock use input and one call shift stock balance. This is to monitor the stock use in each shift and what is the balance after each shift.

Our shift hours for Day is 0800 to 2000 and Night is 2000 to 0800. When the shift start they will open a new shift stock balance record and the record will capture the last shift stock balance to the new shift stock balance open balance.

My problem here is that both shift run in the same 24 hours and when the night shift operator input the stock use before 0000 mid night the date go into the day shift shift stock balance record. When the operator on the Day shift key in the stock use data, the data go into the night shift stock use balance.

Is they any way to resolve this problem when the operator key in the stock use, the data will go into the same shift stock use balance record.

Please Help.

Here I attach the sample file I create .

Thanks

Cheers

shiftwork.fp7.zip