Ok I thought I found my mistake (I was counting an empty field) so I changed the count to count the GraduationYear field which always has a value. I'm still getting weird results that don't match the portal.
Count counts all related records whether or not they pass the portal filter criteria. Count will show the number of related records as if there were no filter on your portal.
To get a count of records for display purposes only, make a copy of your filtered portal, reduce it to a single row and place a "count of" summary field defined in the portal's table inside the portal row.
Thanks Phil…I thought I was understanding this FM thing but I have a long way to go. I've tried putting the "count of " summary field in the main table by counting the fk for seniors and I get a count of 10 on all records. I tried putting it in the Seniors Table and count the pk for seniors and I get counts in the 500 - 600 range. Right now the relationship table just connects the Senior primary key in the Seniors Table with a Senior foreign key in the Schools table. The portal works fine but when I duplicate the portal and reduce it to a single row and try to use the count of summary field that I created things blow up. Do I need to create another table occurrence for this to work?
Phil I found my mistake…when I was messing around with the summary field I let it go outside the portal and as you know that is a no no. It now work.
Thanks again for your help