count correctly in one view but not the other ?

[jiehuang001]

Say that a database has two tables "table_A" and "table_B". tabel_A has a summary field "table_A_records_counting" which counts the total number of records in Table_A. However, when I create a view based on table_B, and trying to show that count, it always shows up as 1 no matter how many records in table_A. it will count correctly if the view is based on table_A though...

Please get a sample file from http://www.duke.edu/~jiehuang/jiehuang-test.fp7 it shows the problem.

Please help!!

Jie

[Sxeptomaniac]

What about something more like this? You are using summary fields in something of an odd way.

jiehuang-test2.zip

[jiehuang001]

maybe it is an odd way in my sample file. However, it is very common that when I make a report for the VISIT, and at the same time want to show the total number of PATIENT on this report.

[Sxeptomaniac]

In this case you might want to us a relationship and a calculation field that uses Count() on the related records, instead of a summary field. That way it doesn't matter where it is on a layout, and it can easily be referenced elsewhere.

It would be an unstored calculation, but that isn't any change from using the summary field.

[jiehuang001]

Hi, I tried that, but it didn't work either. Can you please make it work on my test file and send to me at [email protected]

Thanks!