I just want to COUNT the number of related records, not the individual entires in the related repeating fields.TIA.
if you really only need a count of the related records, I would use something like:
Count ( RelatedTable::PrimaryKeyField )
Thats what I have now, 10 related records with 14 entries in total.
With this calculation I return 14 (total entries) Not just the count of related records.
There appears to be some confusion here between "related records" and "repeating fields". Might it be the case that each related record has a repeating field and you want only to count the values in the first repetition of that repeating field in the related table?
If that's the case you'll need to use a different approach, such as a calculation field in the related table that only has a value if the first repetition is not empty and then you count that field instead of directly trying to count values in the repeating field.
Yet another reason not to use repeating fields--something originally created back in the "flat file days" to provide an approximation of a one to many relationship while staying within the limits of the Flat File structure had back then.
Thanks for the contribution. I seldom use repeating fields for such reasons exactly.
To be clear: I have a COMPANY table and CONTACTS table.
The CONTACTS can be related to ≥1 of the COMPANIES.
I use the COUNT function to return the number of related records based upon the relationship, however COUNT returns the total number of entries in the related repeating filed.
I guess I should specify COUNT related records of a NON repeating field.
I can't tell from your post. Are you using a repeating field in your related record or not?
If yes, then my last post fits. If no, refer back to David as I would tell you the same thing.