Forum Discussion

AvinashHiremat1's avatar
AvinashHiremat1
Qrew Member
3 years ago

How to create summary field with non unique values?

I have a "Tests" parent table and the "Test results" child table which consists test result as pass or fail. 

How I can display test results (combined texts with non unique values) in the "Tests" table.

For Ex: Test Result 1 - Pass, Test Result 2 - Pass, Test Result 3 - Fail then I would like to display "Pass", "Pass", "Fail" in the Tests table.

Appreciate your help on this.

------------------------------
Avinash Hiremath
------------------------------
Relationships

2 Replies

Sort By
  • DonLarson's avatar
    DonLarson
    Qrew Commander
    3 years ago
    The simplest answer is to embed a report in your parent table of the child records.  The Summary field is not really needed since you want data from each child record and not a summary function such as totaling or counting the number of records.

    ------------------------------
    Don Larson
    Paasporter
    ------------------------------
    • AvinashHiremat1's avatar
      AvinashHiremat1
      Qrew Member
      3 years ago
      Thanks @Don Larson.

      But I need to display the test results in the parent table report and not in the view page so that test results can be seen for each tests.

      ------------------------------
      Avinash Hiremath
      ------------------------------