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 rec...
  • MarkShnier__You's avatar
    4 months ago

    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.