AnsweredAssumed Answered

Calculated field

Question asked by SPED75 on Dec 1, 2009
Latest reply on Dec 1, 2009 by SPED75

Title

Calculated field

Post

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?

 

Thanks,

Steve 

Outcomes