Hi,

Well, I have this Evaluation table with atleast 15 fields - Event Code,Department, Job Title, etc. I need to calculate number of records from a particular department, number of records from people with a particular Job title etc. So I made a lot of self joins with different fields. I also need Count of records with a specific JobTitle from a specific department, say records of Professors from chemistry department. So I created a text field JobDept, which is Auto-Enter with Calculation - "JobTitle & Department" and made a self join relationship using this field.

I created another field which is a number with auto-Enter with Calculated value - Count(RelationshipName::JobDept). I did this for all the combination of fields of which I needed a count. So I did 14 self Joins!! All the "Counts" work except for one. I checked a number of times and I haven't made a mistake in making the relationship or anything.

So is there like a maximum number of self joins one can make to a table? I actually redid the whole thing and I get the same error. One Count field is never populated. It remains empty. I tried changing it from a number field to Calculation field and it doesn't help. I am not sure what the difference is anyway...

Does anybody have any ideas?

Thanks.

Does the final Count field return a question mark or any sort of data at all? Is it based on an unstored calculation? You could stuff the file, attach it, tell us which field isn't working, and we could play around with it.