I'm still learning the FM calculation syntax...it just hasn't clicked yet. I have a simple problem that needs a simple solution (to anyone but me).

I have a calculation field in one table that needs to return a total COUNT of records from another related table If the records in the other table are = "enter text here."

I've been messing around with a few different functions, but I can't get it right. Help is much appreciated!

...needs to return a total COUNT of records from another related table If the records in the other table are = "enter text here."

If a determined field of the related record as that string inside, than you have to count that record

[color:red]OR

whatever field contains that string, than you have to count that record ???

That makes sense. However, writing the calculation is still stumping me. I keep getting errors in my script when I try to save it or it returns nothing at all which leads me to believe I'm going about it all wrong. Do you have a suggestion?

Hi mcinfly

my post was a question !

Row 1 or Row 2 ?

Row 1

So two fields in the related file:

Trigger - calc field and calc:

Case(

yourTextField = "enter text here" ;1;0

)

Count - summary field (count of trigger)

That worked like a charm! I was so close to it on my own too. Oh well, one more thing for me to store in my mental FM library. Thanks for all your help!