Yes/No in two Tables

[R]

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!

 

[Duane Hookom]

Consider reviewing the table structure at
http://www.databaseanswers.org/data_models/library/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.

 

[Sharkbyte]

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

 

[Sharkbyte]

Test