Struggling with counting records

[James Gill]

I am trying to set up a calculated field that will give me the name of each related record in a portal based upon which record number it is.

Basically, what I want to do is create a calc that will name each row of a portal whatever number of a series that the portal row falls in to and also count the total number of related records. i.e. - 1 of 5, 2 of 5, 3 of 5, etc.

I'm not sure where to put the calc. It would make more sense to put it in the parent relationship so that it can count the related records, but when I do this using a count ( related record) field it only gives me the total number of related records in my portal.

[James Gill]

Well I sort of got what I wanted by using the @@ symbol and then creating a calc field in the parent record that counts the related records. I'm still curious if there is a way to accomplish this via a pure calculation field though.

[comment]

Where do you want to use this? In the portal itself?

[James Gill]

Two places, in the portal itself and in the related record as a name.

Edited December 1, 2010 by Guest

[comment]

In the portal, you could use a calculation field (defined in the child table) =

Get ( RecordNumber ) & " of " & Get ( FoundCount )

This will work dynamically, so if you delete or add a record, or change the sort order of the portal, records will be renumbered to reflect the change.

Not sure what you mean by "in the related record as a name". The "related record" doesn't know it is related; in fact, it could be related to many tables or related to the same table in more than one way.