lavaface Posted August 19, 2004 Posted August 19, 2004 I have created a field that we will use a barcode scanner to enter items (such as headphones, zip drive) that students check out for use in the lab. The barcode scanner enters a return after each scan and I have it all in an "items out" field. Clicking on a "Check Out" button commits the record. When you click on the "Check In" button a script is called that brings up a dialog box. Here, we would scan the items back in. I modified the dialog so there is no default button, otherwise the return signal from the barcode scanner would only be able to enter one item. This enters the barcodes as one continuous text value. I need to be able to break the barcodes apart and compare them with the "itemsout" field. The thing is, I also need to account for the fact that they probably won't be scanned in the same order. I guess I need to sort the "words" within a field How do I do this? This seems like a trivial question but it's really got me stumped. Perhaps there's a better approach . . . Thanks in advance for any help y'all can offer.
Balder Posted September 17, 2004 Posted September 17, 2004 Just a suggestion: Use a related table: ITEMS Fields : Student_id, barcode, flag ('In' or 'Out'), barcode_in, check_out_date, check_in_date. Create a relation from student_id in the main table to the student_id in items Write the items that students check out to the ITEMS table. Fill the fields student_id, barcode, flag (='Out') and check_out_date. Present a portal , showing the items he / she checked out, . Show in this portal the item and the field barcode_in. Let them scan into field barcode_in and let them start a script by means of a button in this portal-row. if barcode = barcode_in then set field Flag to IN. Now you can trace all movements and see the history per student as wel... does this help?
Recommended Posts
This topic is 7375 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 accountSign in
Already have an account? Sign in here.
Sign In Now