>>>>You really should spend some time getting to learn the SQL commands. All this code can be replaced by ONE line if you use SQL syntax

>>>>Update books set clientID=clients.clientID where books.clientID=globalclientid

>>>
>>>welll.....i did SQL at scholl but not much...:D but thanks
>>
>>SQL is usually faster and also safer than normal VFP code. And if you later plan to move your data to a real SQL server, most of the work is already done.
>hmmm..where can i get SQL certified

I don't understand your question. I am talking about the SQL syntax which is built into in VFP.