1 Reply Latest reply on Nov 25, 2009 8:23 AM by philmodjunk

    Help with Calculation/Query/Filter???



      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.