Hi, how to pull master detail report I have a Master table and two detail table Detail1 and Detail 2, how can I combine a report to include data from all 3 tables.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

of the two detail table anyone table can be populated with 1 - n rows.     

Photo of Tribs

Tribs

  • 20 Points

Posted 4 years ago

  • 0
  • 1
Photo of Natalya

Natalya

  • 50 Points
Good afternoon Tribs,

Unfortunately when you do have a parent that has two different child tables there's not a very easy way to get the data from all three to populate. What I usually encourage customers to do is create a report in both child tables that pulls the data that they need from the parent, and then have these side by side on the app Dashboard.

If you are looking for a more condensed way to create this, it would require creating yet another table to pull all the data from these three tables into it. If you were looking to go this route, I would encourage you to submit a support case so that we can help you walk through it correctly.

Thanks for reaching out today and I hope you have a wonderful weekend!

Natalya Waye | Customer Care Representative