>>>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