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