Forum Discussion

Qrew Trainee

2 years ago

Join table has many matches: how to embed reports

Hierarchy: Roles < Templates < Classes < Points I have 5 tables: Roles, Templates, Classes, Points, and a join table that has several match types, since it's a many to many in all cases: - Role t...

Quickbase Community Post 020623.xlsx11 KB

ColleenBurch

Qrew Trainee

Thank you for this information. When I pulled the field for that record ID down to the grandchildren and great grandchildren, some, but not all, records populate in the embedded report. I used combined text fields to pull from the match lookup to the grand parent (templates) and great grandparent (roles) tables. See attached diagram for the hierarchy structure and how I utilized combined text fields and lookups. Is this the right way to structure this, given I have 1 join table with different match types?

------------------------------
Colleen Burch
------------------------------

MarkShnier__You

Qrew Legend

2 years ago

If you'd like, contact me directly by the email in my signature line and I will have a quick look at your actual relationships. I can't really tell the actual relationships from that Excel sheet you posted.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------