Using MS ACCESS to create routings in process flow
Posted on 2015-01-20
I have a production process with 5 processing centers, for instance:
PC1 is forming
PC2 is welding
PC3 is final assy
PC4 is testing
PC5 is Crating
I would like to create a routine in MS ACCESS that generates all possible paths (routings) for a part or set of parts subject to the following conditions:
Parts can go to any sequence of process centers, minimum number of steps is 1, maximum is 8. I would like to be able to specify the min and max limits.
There are a couple of configurations:
1) Parts can visit the same process center more than once but I'd like to be able to specify the limit of visits to any one process center to 3. So, for instance, I would allow a PC1, PC3, PC4, PC5, PC3, PC4, PC3, PC5 routing.