access help in forms!

[ducthang88]

here is the scenario:



Ive created 2 tables which are
Books (accessno,title,author,copies)
Borrowedbooks.. (title,author)


Im the form of Books, ive created a button in which the title and author fields will insert into the borrowedbooks' title and author fields and will Decrease its copies by 1.

what i want now is when i will delete the data in the Borrowedbooks, i want to increase the copies in the books form by 1 wherein it will add the data similar to the title or author in the data of the Borrowedbooks


For example:

books form

accessno: 1,2,3
title: one,two,three
author: uno,dos,tres
copies: 1,2,3

i chose the 1st data so the Borrowed books will look like
title: one
author: uno


while the books

accessno: 1,2,3
title: one,two,three
author: uno,dos,tres
copies: 0,2,3
(note one uno book -1 copy)

now i want is when i want to delete the title: one,author:uno field in the Borrowedbooks, the title: one author:uno field in the Books table have +1 copy.

accessno: 1,2,3
title: one,two,three
author: uno,dos,tres
copies: 1,2,3

[NoellaG]

Hi,

maybe it's easier when you review your database structure:
you need more tables, for example

tblAuthors
-----------
autID (autonumber, primary key (=PK))
autName
....

tblBooks
-------------
bookID (autonumber, PK)
bookTitle
bookISBN

tblBooksAuthors
---------------
bkaID (autonumber, PK)
bkaBook (Long Integer FK to tblBooks.bookID)
bkaAuthor( Long Integer, FK to tblAuthors.autID)
...

tblCopies
-----------
copyID (autonumber, PK)
copyBook (Long Integer, FK to tblBooks.bookID)
copyPrice (Currency)
.......

tblPersons
----------
perID (autonumber, PK)
perName
.......

tblBorrowedBooks
-----------------
bbkID (autonumber, PK)
bbkBook (Long Integer, FK to tblBooks.bookID)
bbkBorrowedBy (Long Integer, FK to tblPersons)
bbkBorrowedOn (date)
bbkReturned (Yes/No)
bbkReturnedOn (date)
.......

greetings
NG