"I am hoping to print of class lists of over due books at our library. I am unsure how to do this."
Solution 1: In the loan.map file define mapping for EXTRA1 and/or EXTRA2 data fields. If you define EXTRA1=CUSTOM1, assuming you store class information in CUSOTM1, the borrower class value will be stored in the loan's EXTRA1 data field. With this data saved you can sort, group, search by class in the Manage Loans window. You can find loan.map file in the c:/handy_lib/data/db folder.
Solution 2: See our help topic on how to create a query in the Custom Views window.
SELECT B.NAME, B.CUSTOM1, C.TITLE, A.RETURNDATE, A.DUEDATE, A.LOANDATE FROM LOAN A JOIN BORROWERS B ON A.BOR_IDNO=B.BOR_IDNO JOIN LIBRARY C ON A.ITEM_IDNO=C.IDNO WHERE B.TYPE='Child' AND A.RETURNDATE IS NULL ORDER BY B.NAME
Tables and fields used in the query:
A - Loans table (LOAN), data fields: RETURNDATE, DUEDATE, LOANDATE, ITEM_IDNO
B - Borrowers table (BORROWERS), data fields: NAME, CUSTOM1 (student's class is stored in this field), BOR_IDNO
C - Libary Items table (LIBRARY), data fields: TITLE, IDNO
This part defines data displayed:
SELECT B.NAME, B.CUSTOM1, C.TITLE, A.RETURNDATE, A.DUEDATE, , A.LOANDATE
This part defines what tables are joined and by which data field:
FROM LOAN A JOIN BORROWERS B ON A.BOR_IDNO=B.BOR_IDNO JOIN LIBRARY C ON A.ITEM_IDNO=C.IDNO
This part defines conditions for results to be displayed:
WHERE B.TYPE='Child' AND A.RETURNDATE IS NULL
In order to print a report you will have to save the query and define grouped report by CUSTOM1 data field.
Handy Library Manager
Copyright © 2021 · All Rights Reserved · PrimaSoft PC