>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?
That is why DataBase is designed for :-)
To use its Referential Integrity.
Just make open your DB, make ALL necessary relations between this table (Parent) and all child tables.
Then click on "Edit Referential Integrity" and choose what you want to do in INSERT/UPDATE/DELETE.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.