AnsweredAssumed Answered

Filter relationship

Question asked by SPED75 on Nov 30, 2009
Latest reply on Nov 30, 2009 by philmodjunk


Filter relationship


I am new to Filemaker running version 10, creating a database for property management.


In my database I have a Properties tables and a Leases table in a one to many relationship.  There is an Actual End Date field in Leases.  If this is less than or equal to the current date then the lease has expired.  


How do I create a relationship filter to only show the leases that are current ie the Actual End Date is empty or greater than the current date?