Post Author: helliott
CA Forum: General
I need to pull a list based on the following situation.
I need a list of custumers who have never buit a home at our community.
Database tracks this way.
Custumer Table - tracks customer specific information such as name, address etc....
Contract Table - tracks the properties associated with each customer and information specific to the contract details
I build a report that selects all customers with a contract to give a list of all owners. The Build field indicates if the custumer has built on the property with a under construction or a complete entry.
There are customers with more than one piece of property. I need the report to look at all the contracts for the customer and if any of them say under contract or complete then filter the customer off the list.