web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Matrix/Comparison Table
Customer experience | Sales, Customer Insights,...
Suggested answer

Matrix/Comparison Table

(0) ShareShare
ReportReport
Posted on by unicorn_tech 91
Hello. I could use some logic advice.

My final goal is to have a matrix table of plant and plant specifications, with columns for mother, father, comparison plant and comparison plant 2.

The specs are things like Harvest time, Plant shape, etc.
 
So Column A would be the specs.  Column B would be the plant spec details, Column C would be the mother spec details, Column D would be the father spec details, Column E Comparison Variety 1 spec details, and Column F Comparison Variety 2 Spec Details.  This report is the final result I want.  The question is how to build this in the database?

Each plant has an assigned mother (same entity), father (same entity), Comparison Plant 1 (Comparison entity), Comparison Plant 2 (comparison entity.)   Many plants can have the same mother or father, or the same comparison variety(s). The obvious problems are linking records within the same entity, or linking two records (comparision varieties) to a single record.
 
Are there developed models that I could look at? 

 
I have the same question (0)
  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Matrix/Comparison Table
    Unfortunately, there are no developed models.
    But based on your description, I think it could be implemented this way:
    1.Create one table--Plant.
    2.Establish four 1:N relationships between the entity and itself.
    --With these relationship, four lookup column will be created.
    3.Create columns(Harvest time, Plant shape) and add them to the quick view form.
    4.In the main form, add all columns you need and add quick view control for these four lookup column.
    Result:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Hamza H Profile Picture

Hamza H 141

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 132

#3
DAnny3211 Profile Picture

DAnny3211 130

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans