So... the down and dirty... I'm writing a program for scheduling multiple production lines which will be used my multiple users... not a big deal for me, with the exception I'm just really starting to mess with VBA.
Here is what I want to do. I have a daily schedule by line. There are multiple parts being built on this line in a day. Lets say there can be up to 40 or so units, each with a unique serial number.
The way this is set up, the scheduler goes in, sees the units that are available to schedule. They assign a date and a sequence to build this. In the background, I after they assign the date and the sequence they want the unit built in, I have an Afterupdate Event that takes the line, the date and the sequence and makes a unique record. I was doing this so I had a unique sequence for this line and date. So they could not schedule more than one unit per day.
This would work, but I need a way to set it so the scheduler can easily change the sequence.
If we are building an A1A (sequence 1) and an A1B (sequence 2), they can change the A1A sequence from 1 to 2, and this will delete the sequence 2 for the A1B, so they HAVE TO resequence A1B.
Any thoughts on how I might accomplish this?