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.
Derrick Evans
shared this idea
1 comment
-
Alex
commented
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