Exactly, and that is a no-brainer, I have to sort the design to get this working properly otherwise I spend way too much time supporting users when the process fails.

Thanks...

Its possible though more longwinded as there are 10 or so lookups done and the way the original designer has done it, he does all the lookups and then strips...

John

Thanks for the advice. I will be looking into it.

Mark

Rajesh

Thanks for your suggested query. I was able to use it to help me get a working solution although I then ended up changing tack slightly and using a...