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?