Check out system
I am creating a check out system. I currently have three tables:
Product, Product Details, Status
Basically, a button is and a new record is created in status with the date, product and person checking it out. To check in, there is a button to find the previous check out and mark a check in date.
My trouble is in creating a list of products that are in/out. How would I do this? I have created a field called calcIsIn. I do not know how to determine if the Product is in. Is there a "last" function that could determine if last record has an empty check in date?