This worked brilliantly. Thank you again.
Guys, I like the approach. However I would like to share with you guys that the solution is not so flexible. It ties us to some standard transition comment pattern (like "Go To") . What if the customer does not like the transition comment and wanted us to change it. If we change the transition comment then we have to change the Java code. So is it not inflexible ?Is there any other ways that we can find the successor IDs without using the transition comment approach ?Thanks & Regards,Mohamed