>>>>>Hello!
>>>>>im wondering about somethin. I have a clientID and it has a control source in a text box so when i save the client id gets saved in clients.clientid. im wondering is there a way i can send that to example books.clientid as well?like...give one text box 2 control sources?
>>>>
>>>>No, but you can do replace command in the textbox.InteractiveChange event (or in Valid event - may be better)
>>>>
>>>>replace ClientID with this.value in Books
>>>
>>>ah lemme try the top of my head again on this 1
>>>
>>>SELECT books
>>>SET order TO clientid
>>>SEEK globalclientid
>>>IF FOUND()
>>>replace books.clientID WITH clients.clientID
>>>ELSE
>>>ENDIF
>>>
>>
>>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.