Trying to count using where with child and linked tables data

Hi,  I am new here and have spent a long time trying to do a simple count count formula.

I can use cnt(Observations.Regulation.Code) to easily count all the codes on the form, but what I want to do is something like cnt(Observations.Regulation.Code where code = "C1") so that it only counts codes with C1 in this record.

The stucture is quite basic, but I just cant seem to get the where count to work, tried lots of various select statements but I can only get this to return information from the Regulation table for example. cnt(select Regulation where Code = 1) counts all the records in the Regulation table, but I cant relate this back to the current Report table.

Table - Report
   child - Obb

Table - Regulation - Linked to Obb

2 replies

    • Jan_Inge_Iversen
    • 2 yrs ago
    • Reported - view

    No answer???

    • John_Halls
    • 2 yrs ago
    • Reported - view

    Replace where code  = "C1" with [Code = "C1"]

    The where and square bracket formats both work with select statements, only the square bracket format works with a relationship field.

Content aside

  • 2 yrs agoLast active
  • 2Replies
  • 744Views