Jump to content

Relationship Need Help


gregorytan
 Share

This topic is 4332 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

This topic is 4332 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.