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.