I have a custom object
Customer__c that stores contact and address information (along with other information).
Every time a contact is created without inserting an address, a record of
Customer__c is created with
Contact_ID__c = 'contacts id' and
type = 'Contact'.
Every time a contact is created with address, two records of
Customer__c are created. One with
type = 'Contact' and another with
type = 'Address'. Both have
Contact_ID__c = 'contacts id'
If I am given a set of
Contact_ID__c, how can I query for records of
Customer__c that only have a record of
type = 'Contact' and don't have a record of
type = 'Address'? In other words, I want to get the contacts in the set that don't have an address.
Is it possible? Thank You.