get(foundcount) not working

[FrostBite]

I have a calc field called cFoundCount and the formula is simply Get (FoundCount).

cFoundCount is in my JobNumber table and I have a layout called JobNumber. when I go to that layout and look in Data Viewer for my cFoundCount value it shows 76 records which is the total amount of records in that table. good so far. Then I go to find mode and search for a specific JobNumberID and I find one record. I refresh Data Viewer and it still shows 76. refresh, refresh, refresh! *******. I guess it's really not going to show me 1.

Why is it not displaying the number of records in the current found set?

[FrostBite]

found the problem.

filemaker knowledgebase