AnsweredAssumed Answered

Help with Calculation/Query/Filter???

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


Help with Calculation/Query/Filter???


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.