Showing records from same table but for different types

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have stores table which has relationship to projects table. Within the projects table, I have two different project categories and there are different teams working on these categories. It was relatively easy to establish a report link field (from a child table - initiatives) and show two separate sections so that one team knows if other team is working on a different initiative in the same store. 

But now these teams would like to see relevant projects from table projects. How do I show these projects as a section within the same form?   
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
What is the definition of "relevant projects"
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Mark projects match the same store identity.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
B y "identity" do you mean like a Banner, or the actual Store.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
That would be the related store on the store table id in projects table and matching with category field in project table as 'PNP".
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
If you want to have multiple report link fields on the form you can.  Each report link field can have a different report filter, for example to filter just certain Project categories.  But it sounds like you already have two separate report link fields for projects on your Stores Table.  So, now I don't think I understand the question.