Forum Discussion

NicholeStebane's avatar
NicholeStebane
Qrew Member
4 months ago

Building a report from multiple tables

From the parent table (FWA Investigations) a task record (child table: Tasks) can be added and displays in the parent table. I want to create a report that will show me when there aren't any task records that have been created under the parent table. 

  • np,

    Go to the relationship where one FWA Investigations has many Tasks.

    Make a summary field using the option of if there are any Tasks.  That will end up being a checkbox field type.

    Then create a report on FWA Investigations filtered by that chechbox summary field.

  • np,

    Go to the relationship where one FWA Investigations has many Tasks.

    Make a summary field using the option of if there are any Tasks.  That will end up being a checkbox field type.

    Then create a report on FWA Investigations filtered by that chechbox summary field.