Yes/No in two Tables

Hello-

I'm creating a Book database and im having some trouble. I have one table
that stores the book's information called tblBooks. One field in this table
is a Yes/No field. And if the book is loaned out then their should be a
check mark in it. I have created another table called tblLoan that stores
who loaned what out. I have a combo box that grabs the book titles so the
user can pick what book to loan out. Is there a way that I can add another
Yes/No to this table and when it is checked in the Loan table, the check in
the tblBooks table be checked??

Thanks!

Consider reviewing the table structure at
http://www.databaseanswers.org/data_...rary/index.htm. If a book has
any records in the [Books out on Loan] table that don't have a return date
then the book is out. There should be no reason to maintain values in two or
more tables.

--
Duane Hookom
MS Access MVP


"R" wrote in message
...
Hello-

I'm creating a Book database and im having some trouble. I have one table
that stores the book's information called tblBooks. One field in this
table
is a Yes/No field. And if the book is loaned out then their should be a
check mark in it. I have created another table called tblLoan that stores
who loaned what out. I have a combo box that grabs the book titles so the
user can pick what book to loan out. Is there a way that I can add
another
Yes/No to this table and when it is checked in the Loan table, the check
in
the tblBooks table be checked??

Thanks!

Using the AfterUpdate event, for the Boolean (Yes/No) field tied to tblLoan,
you can add an Update statement to trigger the Boolean in tblBooks.

Sharkbyte



"R" wrote:

Hello-

I'm creating a Book database and im having some trouble. I have one table
that stores the book's information called tblBooks. One field in this table
is a Yes/No field. And if the book is loaned out then their should be a
check mark in it. I have created another table called tblLoan that stores
who loaned what out. I have a combo box that grabs the book titles so the
user can pick what book to loan out. Is there a way that I can add another
Yes/No to this table and when it is checked in the Loan table, the check in
the tblBooks table be checked??

Thanks!

Test

"R" wrote:

Hello-

I'm creating a Book database and im having some trouble. I have one table
that stores the book's information called tblBooks. One field in this table
is a Yes/No field. And if the book is loaned out then their should be a
check mark in it. I have created another table called tblLoan that stores
who loaned what out. I have a combo box that grabs the book titles so the
user can pick what book to loan out. Is there a way that I can add another
Yes/No to this table and when it is checked in the Loan table, the check in
the tblBooks table be checked??

Thanks!