Hello All, I am tasked with a project where I need to solve the impact of constraints. To do this I need to figure out all the tasks that are successors to the tasks that are constrained. I have a list of all the tasks along with their immediate successors and immediate predecessors. I would like to be able to form a list of off successive tasks until the completion. In My example I would like for a shortage in E to tell me that all the successors are D, H, I, J, and K. If I have a shortage in task B I would like to know that tasks F, G, and K are constrained as well. My list has over 3000 operations but they are broken up into 10 groups so around 300 operations per group.(to give you an idea of the size). I need them in a format that I will be able to delete duplicates so I am not counting the same operation twice when I have multiple constraints. Any and all feedback is greatly appreciated. Thanks.[TABLE="width: 500"]
<tbody>[TR]
[TD]Operation
[/TD]
[TD]Successor
[/TD]
[TD]Predecessor
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]C
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]D
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]F
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]G
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]E
[/TD]
[TD]D
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E
[/TD]
[TD]H
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]I
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]J
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]I
[/TD]
[TD]K
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]J
[/TD]
[TD]K
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]F
[/TD]
[TD]K
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]G
[/TD]
[TD]K
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]Operation
[/TD]
[TD]Successor
[/TD]
[TD]Predecessor
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]C
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]D
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]F
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]G
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]E
[/TD]
[TD]D
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E
[/TD]
[TD]H
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]I
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]J
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]I
[/TD]
[TD]K
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]J
[/TD]
[TD]K
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]F
[/TD]
[TD]K
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]G
[/TD]
[TD]K
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]