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

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • No answer???

  • 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.

Like Follow
  • 1 yr agoLast active
  • 2Replies
  • 737Views