Hi Cetin,

>Practically I wouldn't try to do this in one SQL.
"...as the code would be shorter and quicker" statement is not right IMHO. You might be surprised multiple SQL and/or xbase commands might perform much better.
Many highly optimized code are tricky but this one is more understandable and easy to implement IMHO (if you testdrive it vs SQL solutions I'd like to know the result - with this code as is it takes 0.11 seconds on my system : AthlonXP 2500+,512Mb,64Mb is used by on board VGA. Still room to optimize it sounds)<

I will attempt to test your code soon. My system is similar to yours except I am using an Athlon XP 1800.

If you will look at my responce to Fabio's SQL sample code, it actually processed 3,500 parent tables in .41 using his code - and I was a little surprised by that.

Thanks for your help.

Mel Cummings