Thanks to one and all. My apology for delayed response. I have taken the logic of GrandFather and tweaked it to my requirment it WORKED. I was caught up with that work. Special thanks to GrandFather. I cannot do it from the database as there is a constraint in the logic built. Thanks, Dinakar