Microsoft Dynamics CRM Advanced find

I need help creating a report.  On our website, we ask demographic questions of our users.  These are stored as a separate forms record.  My issue is that I cannot figure out how to pull both the contact information I need (First name, Last name, Institution, email, and primary phone number) as well as the questions and their respective answers.  I can get one or the other but not both on one report.

Ideas?  Suggestions?  Questions?

Thanks,
ACUIWebDeveloperAsked:
Who is Participating?
 
ACUIWebDeveloperConnect With a Mentor Author Commented:
Our System Administrator figured it out on his own, but does not remember what he did exactly to make it work. So, unfortunately, the answer is not available for posting. Thanks anyways for all comments.
0
 
Feridun KadirPrincipal ConsultantCommented:
Am I right in thinking you have a contact (or user?) record that has linked to it multiple questions and answer records?

If so, then there must be a linking field from the q an a record to the contact. In Advanced Find, run the query of the Q and A record. Then when you select Add Columns click in the drop down at the top of the windows (Record Type) and then select the parent record type, contact. Then you will see contact columns which you can add to the results view.
0
 
ACUIWebDeveloperAuthor Commented:
No actual solution specified because it was not available.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.