Get a summary on a form layout?

[aldipalo]

What I would like to accomplish is summarize how many contacts are related to a specific CompanyID when I am looking at the Contact record. Ideally, I'd like to have a field sitting next to my CompanyID field that simply states XX number. I guess a similars summary but without the portal. Can it be done and if so how? I tried all the variations when setting up a summary field without getting the desired result.

Thanks for the help.

Al

[John Mark Osborne]

Use the Count function in a calculation field in your Company table. For example:

Count(RelationshipToContacts::kp_contact_id)

You can count any field you like but you need to make sure it always has a value in it. Therefore, I usually choose the primary key field from the table.

[aldipalo]

Thanks for the reply John Mark:

Works perfectly!

Al