I'm having a problem figuring out how to have my status indicator break down how many records are in "status a" and how many are in "status b" on a report. I'm trying to eliminate having to search all the time. I want to know everything at a glance. How hard would it be to do in FMP5? Everything is on one table right now.

Assuming that 'status' is a field then one way would be to use relationships and the Count()function.

Create a global field 'G_match'. Create a relationship between match and status. Call this relationship 'stat_count'

Create another field called stat_total. Set it to be an unstored calc field with the formula Count(statcount::anyfield that def.isn't empty).

If you now set G_match to 'a', stat_total will show you the number of status a's that you have. If you change G_match to 'b' stat_total will display the number of records that have 'b' in them.

If you want to see both at once you will have to repeat the same process with another global another relationship and another calc field then set one global to 'a' and one to 'b'

This might all seem a bit clinky but it will work in 5 as well.

HTH

Phil

Edited December 4, 200619 yr by Guest

Do I have to create a new file or can I relate it using the same file?

You can use the same file

Phil

If I needed to do something similar in FMP8.5 would I need the same calcs?

Here is my original post.

http://fmforums.com/forum/showtopic.php?tid/183266/post/234221/hl//

Edited December 29, 200619 yr by Guest