trying to do: a list of contact persons which has a relation as NPS contactperson
expect to happen: get an overview of all NPS contact persons with emailadress and phone number from SuperOffice mirroring database
actually happened: The current result shows part of the content, but some companies are missing in the results, while they show a 'relation with NPS' in SuperOffice.
steps to current situation: The build up of the list starts with contact table. Other tables connected to this are business, category, email, person, phone, phoneformat, relations and relations definition. Current connection with relation is based on registered associate ID from contact to relations. And from relations to relationsdefinition it's reldef ID. Clearly this doesn't work.
question: Can you please explain how to connect relationdefinition properly and get a list of contact persons/companies/phone number/emailadress/ NPS contact person as relation?
With kind regards,