Help with my design

[lipin]

I have a small application used by warehouse auditors. The main form is a username and password form. The second is the form where they enter the carton number, # of units in carton, employee that filled it, and reason for audit.

If there are no errors in the carton they hit next carton button to go to the next record. If there are errors they hit the Record Errors button to make visible a subform at the bottom where they put all the error info.

The employee that made the error is called over to sign off on error. They do this with a password for each employee.

The problem is it may be 5 min to 1hr before the employee comes over to sign off. I need the auditor to keep working and when the employee comes over to sign off be able to quickly retreive the error record that they entered on the subform.

How can/should I do this efficiently?????

 

[Newman]

Pretending that errors are not common, you could do another form with a query showing only the records where there is errors and no password.

This way you get a listing of all the errors that were not approved and moving thru them you'll find the one the emplyee has to sign on.

Hope that helps!
Newman

 

[lipin]

I will get a little more specific

There are 6 auditors working on 6 terminals at any one time. Say Auditor # 7020 has done 20 audits and found 32 errors by 8:00a.m. At 12:30 p.m. she has entered many more audits and errors are over 100 now. An employee from her first audit needs to sign off on his error.
How should I go about finding that error so he can sign off on it?
Any Suggestions?

With six auditors there will be several hundred records for that day and I employee may have errors recorded by more that one auditor. I don't think scrolling through all records will work. ANd the users using this application aren't the most computer literate so the simpler the better.

 

[Dave Eyley]

Hi lipin

Why not have an additional field, perhaps a checkbox in the main table. The Auditor finds the error, fills in the error report and checks the box. The checkbox indicates that the error has not been signed off.
When the employee arrives they run a search to find all the records with are 'checkboxed' and have the employee's ID.

When the employee signs off the error, the auditor clears the checkbox, or it is done automatically, by an action related to the correction, and then continues with the rest of the errors. Because the errors have been tagged when found, a simple search is all that is needed to find them again.

HTH

Dave E