Unrelated to your scatter problem, you may want to change your code from
go top
to
locate
On small tables you might not see a difference, but on large tables it will be tons faster.
P.S. Did not know anyone in Lexington was using the Fox. :)
Jeff
>Thanks for the tip. The issue was not with scatter/gather. I have a routine that exports data in the form of a free table. I use a SELECT-Sql to create my free table. That is truncating my field names to 10 charachters. SO when I go to scatter/gather, they arent getting populated, the field names dont match up. The exported table needs to remain free.
>
>Any solutions, other than renaming all my fields?
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com