In & Out Form

[AccessHelp]

Hello all,

I am in the process of designing a form where users can log the books that
students check out from the library. The problem that I am facing is putting
tables together and have the info recorded in the "in & out" table.

I have a table for books, students and in & out. How should I link all 3
tables in the Record Source of the form? When the form is open, it will
prompt the users to type in a book ID. Then the form will open only the
records based on the book ID input by the users.

The In & Out table has fields for book ID, student ID, Date In, Date Out. I
have thought of combining the fields in the In & Out table with the Books
table. Then that would not work if I want to keep a record of checking out
history.

Please help. Thanks.

 

[Carl Rapson]

Hello all,

I am in the process of designing a form where users can log the books that
students check out from the library. The problem that I am facing is
putting
tables together and have the info recorded in the "in & out" table.

I have a table for books, students and in & out. How should I link all 3
tables in the Record Source of the form? When the form is open, it will
prompt the users to type in a book ID. Then the form will open only the
records based on the book ID input by the users.

The In & Out table has fields for book ID, student ID, Date In, Date Out.
I
have thought of combining the fields in the In & Out table with the Books
table. Then that would not work if I want to keep a record of checking
out
history.

Please help. Thanks.

The "in & out" table should be a subform on the main books form, linked
through the book ID. That way, when a book is selected in the main form, all
"in & out" records for that book will automatically be displayed.

The main form should only have the books table for its Record Source. The
student ID can be selected from a combo box populated with the student names
from the students table (in the Row Source).

Carl Rapson