Organizations Primary Contact

Andrew Lowrey

When you open an organization to view their record, under the "Relationshiops" tab you can add a "Primary Contact" to the company. I am pulling a query that shows all the organizations that sponsored an event. I can't figure out how to add the Primary Contact name to the output of the query. Anyone know how to so it? Thanks.

JoAnn Strommen

Andrew Lowrey:
When you open an organization to view their record, under the "Relationshiops" tab you can add a "Primary Contact" to the company. I am pulling a query that shows all the organizations that sponsored an event. I can't figure out how to add the Primary Contact name to the output of the query. Anyone know how to so it? Thanks.

This info can be output through Relationships > Individual > Name and Contact Type fields.  However, since query is a grouping tool the query will output all contact names and their type.  So you may have to do some sorting or take your query to Export function to just display type of "Primary".