How to limit student to borrowed 2 books per day
Need help here.
I am currently developing our Library System and I am using Filemaker Pro 11 Advanced. My problem is how to limit student/s to borrowed 2 books per day.
The system will monitor student transactions with in that day on how many books they borrowed. If the system monitor that they borrowed 2 books already, the system will not permit them to borrow another book (3rd book). Student should return first the first book or both books before the system will allow then to borrow again another 2 books. This would happen if they click the check out button (if possible that we can have the script for that).
I'm using the Lending Library relationships from the starter solution of FM. Changed Asset and Contact into Student and Book. What are the fields do I need to add, its properties and what is the script for this. Where did I put the script, in Asset Process Check out or in Contact Process Check Out or in History Process Check Out?
Hope you can help me solve this problem. Thanks and more power FM