J Jay Mar 27, 2004 #1 How would I go about showing that only books not on loan can be borrowed in my library database. Can anyone help.
How would I go about showing that only books not on loan can be borrowed in my library database. Can anyone help.
D Duane Hookom Mar 27, 2004 #2 Yes we can. The problem is that we can't see your library from across the internet.
J John Vinson Mar 27, 2004 #3 How would I go about showing that only books not on loan can be borrowed in my library database. Can anyone help. Click to expand... Without knowing your table structure, I'm groping in the dark a bit; but consider using the "Unmatched Query Wizard" to find those records in the Holdings table that have no match in the Loans table.
How would I go about showing that only books not on loan can be borrowed in my library database. Can anyone help. Click to expand... Without knowing your table structure, I'm groping in the dark a bit; but consider using the "Unmatched Query Wizard" to find those records in the Holdings table that have no match in the Loans table.
