Hi Craig, I have about 1000 students that are in a library system showing them as having checked out an iPad. In the library system it uses the student username and the barcode as the item identifier.
I have another list that shows our iPads by barcode and serial number. Unfortunately there is no way for me to pull a report that shows the student username and the device serial number in one report. So I was essentially searching for the barcode in both lists and then combining the username from one and the serial number from the other. Ultimately ending up with a list that consists of student username and device serial number. I hope that is a little clearer. Thank you! John Patten SUSD > On Nov 16, 2016, at 12:22 PM, dunbarx <[email protected]> wrote: > > HI. > > So, a single list. What is the relationship between the fact that a > particular barcode refers both to a student and a serial number? In other > words, if you had a single list, how would "12345" relate to both "john doe" > and "SDTKNY12345"? > Would you simply have two lines: > > 12345,johndoe > 12345,SDTKNY12345 > > Also, I do not understand what you mean when you said: > > "I have cut my username list down to about 30." > > Does that mean that in your 1000 line first list, the usernames appear with > multiple barcodes? Or are those lines empty? Or is that list now only 30 > lines long? > > It looks like this begs for an array, but I am missing what you expect as > output. Whatever it is, the procedure will be simple. But I cannot even > start to advise about that procedure until I know what the answer is. > > Craig > > > > -- > View this message in context: > http://runtime-revolution.278305.n4.nabble.com/Inconsistent-results-in-simple-script-tp4710376p4710377.html > Sent from the Revolution - User mailing list archive at Nabble.com. > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
