I am new to Filemaker running version 10, creating a database for property management.
I have separate tables for Properties and Leases. There is an Expired field in Leases that contains either Yes or No. I want to create an calculated field in Properties to show Yes or No whether the property is currently empty. This is determined by whether there is a related record in Leases where the Expired = "No". What calculation do I use?