**Short Question: What is the recommended approach for this scenario please:- ** How do we check a barcode is new for a specified Collection [ Client / Batch ] , if new [true] then find the highest Box number ( 1, 2, 3, 4 etc ) already allocated in t...

We are looking to develop a small project to scan barcodes on boxes and to track progress through the office stages aligning info from a spreadsheet inventory and assigning boxes to a person. I am technical and have built a pilot app but time poor so...