You are asking for a lot all in one post. Every time I've looked at this one, I've passed as I didn't have the time to open up the starter solution in order to post an answer in terms of the fields, tables and relationships present in that file.
The basic concept is to use the relationship from Student to History to count the number of related records for books that have not yet been logged as returned. If the count is greater than 1, the student cannot check out another book.
Just from a quick glance at manage | database | relationships, it would appear that you can use
Count ( History Contact ID Flag Checked Out::Contact ID Flag Checked Out )
to count the number of books currently checked out for a given Contact.
Hi Phil, Im sorry for this type of post, I did a lot of search related to that problem but unfortunately I can't have the solution. I made those questions because I know that guys here in FM know that already. But you know Phil, your suggestions above saved me and solved my problem even if it’s hard for me to figure out where to put that script in between the multiple script.
Change Delete Record/Request into Revert Record/Request under History Cancel Process Check Out to not delete the student record when you cancel the process.
Thanks so much..