Avatar of ACUIWebDeveloper
ACUIWebDeveloper asked on

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,
Microsoft DynamicsMicrosoft Applications

Avatar of undefined
Last Comment
ACUIWebDeveloper

8/22/2022 - Mon
Feridun Kadir

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.
ASKER CERTIFIED SOLUTION
ACUIWebDeveloper

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
ACUIWebDeveloper

No actual solution specified because it was not available.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23