I need some advise on the best way of compiling a little bit of software:-
During the manufacture of one of our products we are required to record two numbers per unit, one bar-code that is scanned in and the other is a serial number that is typed in.
I need to ensure that any new barcode/serial numbers entered are not or have not been duplicated - This in itself would be relatively straight forward but:-
I will have four workstations running in parallel that will each have to record and check each entry in real-time.
I'm stuck on the best method of doing this and even if Excel is the best medium to do so, would having a network sheet that the 4 workstations would write/read from work or would it get tied up?