Attaching a user to work done

[SDB]

Okay ket me start from the beginning, once upon a time... , I need to keep a track of all my staffs work progress throughout the day, they currently pack items into envelopes and count up how many they have done at the end of the day..I have started a database that will scan each package with out them having to count it but I want them to logon using a scanned barcode assigned to them and then have all the scanned items assigned to how ever has packed them, but i can't get access to link there barcode to there work done...any ideas

 

[ecniv]

Assuming you can scan and get a code....

To store a record:
User: click in text box (locked) and scan (code is put into the textbox)
Packaged: click in text box (locked) and scan (code is put into the textbox)
Button: Saves whats in the text boxes to a table.

Another table of users used to match the barcode to a user/packager.

I've not used barcode or barcode readers (wanted to) because they are too expensive to experiment with


Vince

 

[SDB]

Thanks for that I just couldn't see where i was going wrong..