Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Adding criteria to a relationship

Dale Johnson

Recommended Posts

OK, I've got two table occurances of the same table:

BehA and EasyDiscipline y.


I've related the field BehA (which may or may not have a 'y' in it)in BehA to a global field called gy in EasyDiscipline y which contains a 'y'.


I have a calc called CountBehA =

Count ( EasyDiscipline y::BehA )


This gives me all occurances of BehA in the dbase.

I want to get a count of BehA for each year.


When I add a second line to the relationship so it looks like this:


BehA = y

AND SchoolYear = gYear


the total count remains the same as it is with only the first line; it is not reduced as expected.


Any ideas why?


Much appreciated - dale

Link to comment
Share on other sites

I can't quite figure out your goofy field names, but it should work if the globals are on the parent side of the relationship and the field types match up. Make sure the Count calc is based on the parent table occurrence, counting records in the child table occurrence.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use