I have a Department status report that each of our department uses to determine in which order to process our cabinets. Management would like to create a form based on this report, so that it is listed in the same order where the user could click a checkbox on each job that was completed. When finished this would update our history table with the checkbox date for the related department.
Report example
JobCode Run Lot SpecialColor Completed(unbound checkbox)
GHHT A 131 Y Y
HHTY Z 13 N
FRBG F 23 Y Y
I created a datasheet form that shows this information. I added an unbound checkbox but if you check one, they all check. I want to able to select lot by lot. I guessing at that point I would need to create an update query that would update tblHistory and the correct department date with date() on the ones that were selected.
Not quite sure how to proceed with this one. The special color field makes a difference on where the date goes. For example if the Mill completes these jobs and it's a special color then the date would go to tblHistory.Assembly. If it's not a special color then the date would go to tblHistory.Prefinished. The primary key between the two is DelID.
Report example
JobCode Run Lot SpecialColor Completed(unbound checkbox)
GHHT A 131 Y Y
HHTY Z 13 N
FRBG F 23 Y Y
I created a datasheet form that shows this information. I added an unbound checkbox but if you check one, they all check. I want to able to select lot by lot. I guessing at that point I would need to create an update query that would update tblHistory and the correct department date with date() on the ones that were selected.
Not quite sure how to proceed with this one. The special color field makes a difference on where the date goes. For example if the Mill completes these jobs and it's a special color then the date would go to tblHistory.Assembly. If it's not a special color then the date would go to tblHistory.Prefinished. The primary key between the two is DelID.
