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

    Help with Calculation/Query/Filter???

    SPED75

      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