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