Report showing related records of related records

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

My tables

  • Handle-Hashtag: social media handles
  • Handle-Hashtag Type: type of social media handle, includes some URL details for calculated fields.
  • Entity: companies
  • Entity Type: e.g., architect, owner, developer
  • Construction Projects: A table connected to a different app that tracks projects.
  • Join_Entity_Projects: to provide a many-to-many relationship (one project can have multiple Entity and one Entity can have multiple projects)

I need a chart that will depict projects, entities, and handle. Im able to create charts that show entity and related projects, as well as entities and related handles but I cant show all three??

Photo of Justin


  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
You list six tables but only describe the two relationships of the join table. How are all six tables related?