Sequential numbers...

[jlgray0127]

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?

[orange]

Do you have a clear list of "Business facts"?
Do you have a data model that supports your "business facts"?
Do you have a clear description - in plain English - of what you are trying to do?

I find this to be "jargonese"

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?

I'm sure it means something to you. But the readers here are really the average person on the street, no real appreciation for re-sequencing A1B.

A clear definition of "line", "part", "unit" , "sequence" would be helpful to the reader also.

The last chance you have to check if a proposed record already exists, or to decide if something should be rejected is in the BeforeUpdate (usually).