Skip to main content

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


1 comment

  • Tiffanie Staver
    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.




Please sign in to leave a comment.

Powered by Zendesk