Solved Filter out Records from the main Table

[sbaud2003]

Hi Sir
I have have a table BOOK and the Loan Table as LOAN, In the issue form while selecting the BookID (Primary Key) In the issue book form, I want the Combobox to display only those books which are avail;able in the Shelves. i.e Books that are issued and not returned.

 

[June7]

You might want to look at MS Lending Library database template.

 

[Gasman]

want the Combobox to display only those books which are avail;able in the Shelves. i.e Books that are issued and not returned.

I do not understand that statement at all?

 

[arnelgp]

on the Loan table, you should add 2 date fields.
one (Loan Date) and the other (Return Date).

something like this.