I want to make a program that tracks which station each of my projects is at using barcode scanners. My small business deals with putting certain lots through certain stations, kind of like an assembly line but the line is a snake that wraps around it self a couple times over and ties itself in knots. I want to be able to print a qr or bar code, slap it on the shell, and send it off to its first station. Then at that station, the operator would scan it, work on it, and send it off to the next station. The next operator would scan in and continue working on the product. During this time, I should be getting updates on my front end showing where each product is, as well as what others have reached that same station and are in queue. If a certain tool is down, I can change the status of the tool to “down.” I want to be able to tell how many lots went through a certain tool so I can price the project at the end of everything. I’ve tried making a couple simple programs in excel, they’ve “worked” but not to the extent that I want. Especially because sometimes lot 1 and lot 2 can combine and become lot 1.2. Excel has trouble stopping the other 2 lots and realizing that they’re one lot now. This program would obviously have some tweaks to it as it goes, but this is the general gist of it.