AnsweredAssumed Answered

Help with Calculation/Query/Filter???

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

Title

Help with Calculation/Query/Filter???

Post

I'm creating a database for property management.  I have a Properties table, a Safety Certs Due table (containing the renewal date for the safety certificates) and a Safety Certs Type table (containing the different types of safety cert ie gas, electric and fire safety).

 

Properties:: PropID = Safety Certs Due:: PropID

Safety Certs Type:: TypeID = Safety Certs Due:: TypeID 

 

How do I create a new layout that only shows the properties that DO NOT have a certain type of certificate? 

 

By the way, I am new to Filemaker and running version 10.

 

Thanks,

Steve 

 


Outcomes