Skip to main content
Question

parent child report

  • June 4, 2018
  • 0 replies
  • 94 views
Have 2 tables:Project and Tasks
Relationship: One Project can have multiple Tasks.

I want to be able to display child records in the parent report without having to display them using a link. Is there a way I could show the child records associated with the parent directly in a report. That being said, there might be cases when a Project doesn't have any tasks, I also want to show those projects in there.

Any recommendations?

Thanks,
    This topic has been closed for replies.

    How many tasks might you need to handle? This can be done, but for a limited number of tasks say Max 6-10
    • DougSwanson1
    • Quickbase Alumni
    • June 4, 2018
    Add the fields you to report on to from the Project table to the Task table as Lookup fields....  The are part of the relationship.  Then create your report against the Task Table....and use the lookup fields that are created in the Task field from the Project table.  I would recommend to Group and Sort by the Project name (Lookup Field).  Let me know if that is enough for you to implement the report you want.
    Terms & ConditionsAccessibility statement