I have a production program I am working on. We have a list of
scheduled productions for our operators to run. Occassionally though
we get an order in that must be run before those that are already
scheduled. I have a sequence field that is used to determine the
order of the current productions. I would like to be able to insert
a new production anywhere in that current list. Below is what I was
thinking. If that looks good to you, can someone help me with the
best way to accomplish that. Sample code would be great.
B. Be able to insert a production higher up in the schedule if it is
determined to be of a higher priority. (For example: A dummy
production is created for a critical production and it must be run
immediately, or if a productions scheduled for later in the shift
must be run sooner.)
I figured that I would create a button, have the event prompt the
user for the production that they wish to supplant, and then have the
code change the current production's Sequence ID to the supplanted
production's Sequence ID, and then increment the supplanted
production's ID - and all subsequent production's IDs - by one.
Sounds easy, but it could be fairly complex.
Here's the sequence of events as I see it.
Scheduler wishes to move Production A to be the next production
processed. (Prod Z is far down in the schedule)
Scheduler determines the Production Number for Prod Z & Prod B, the
next scheduled production. (Using QuickViewer)
Scheduler navigates to Prod Z in the scheduler app. and clicks
the "Insert/Promote Production" button.
A popup should request the Production Number that the scheduler wants
to move Prod Z ahead of. (Prod B)
The scheduler enters the production number, the event procedure
locates the Sequence ID for that production and changes Prod A's
Sequence ID match.
The Sequence ID for Prod B and all subsequent productions should be
incremented by one. (This works if Prod Z is the last production, but
if there were productions already scheduled after Prod Z, then they
wouldn't need to be incremented.)
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
