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 · Mar 17, 2016
How do I create a view that incorporates data from the child tables
Comments
1 comment
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.
Regards,
Alex
Please sign in to leave a comment.