insert into another table from another table

[ducthang88]

this is the scenario... I have a form named Borrower, Books and Borrowedbooks...

From the form Books, i have a command button which what i want is to select the current value on the textbox (BorrowerNo) in the form Borrower and put it in the (BorrowerNo) field in the Borrowedbooks...

[jzwp11]

If your tables are joined properly, you should be able to use a form with a subform to enter the data without the need to execute any code behind the command button.

Could you provide the fields of the tables you mention and how those tables are related?

[ducthang88]

i have a:

borrower table connected to borrowedbooks table (via borrowerno)
-borrowerno(PK)(auto)
-Lname
-Fname
-Mi
-Contact

borrowedbooks table (via borrowerno)
-bookno(PK)(auto)
-borrowerno
-title
-author


Books table (standalonetable)
-accessno (auto)
-title
-author

then ive created a form with 2 subforms..

the main form is the borrower then 2 subforms which is books then borrowedbooks..
the command button is in the books which i want is to copy the value of borrowerno (in the main form borrower) then copy it in the table of the borrowerno in the borrowedbooks

[jzwp11]

Since a book can be borrowed by many people and a person can borrow many books, you have a many-to-many relationship. Your tables are almost correct; the borrowed books table needs a little tweak. There is no need to repeat title/author of the book in the borrowed book table

borrower table connected to borrowedbooks table (via borrowerno)
-borrowerno(PK)(auto)
-Lname
-Fname
-Mi
-Contact

borrowedbooks table (via borrowerno)
-bookno(PK)(auto)
-borrowerno foreign key to borrower table
-accessno foreign key to books table


Books table (standalonetable)
-accessno pk, auto
-title
-author

In terms of forms, you would have your main form based on the borrower table and the subform based on the borrowed books table. Within that subform, you would use a combo box based on the books table to populate the accessno. I do not see a way for you to determine when a book is borrowed/returned. How do you plan on tracking that?