AnsweredAssumed Answered

Check out system

Question asked by FileMakerNovice on Mar 6, 2013
Latest reply on Mar 6, 2013 by philmodjunk


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?