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?