How do I...?

How do I create a view that incorporates data from the child tables

I have a table with 2 child tables. I would like to create a view where I can select columns of data from all 3 tables and display in one view.

1 vote
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Derrick Evans shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Alex commented  ·   ·  Flag as inappropriate

    Hi Derrick,

    It is not possible to pull child fields into one parent view. Due to the nature of relational databases, a single parent record often times has many children and many values for that one chid field that would be in the view.

    In this case, you would need to create three separate views, one for each child, that includes the relevant parent fields. Depending on the use case, you could use a child lookup function that could aggregate the desired child information into a calculated parent field. For example, a concatenation will pull up the list of values from a desired child field.

    Information on creating views can be found here: http://help.trackvia.com/knowledgebase/topics/40972-views-charts

    Functions can be found here: http://help.trackvia.com/knowledgebase/topics/40975-formulas

    Regards,

    Alex

Feedback and Knowledge Base