Hoping there is a quick easy answer....

[FruitFul]

Is there a way to 'count' the number of records within a portal?

For example say you have a portal and next to it is a box with the total number of records (as you switch records, the 'Count Total' adjusts accordingly).

[Ender]

Sure, define a calc field in the parent table that uses the Count() function to count some field in the related file that always has data, like the foreign key:

Count Total (calculation, number result) = count(relationship::key)

[FruitFul]

Thanks! Works great : Next Question...

I was also hoping to also use this new count field in a Value List. Basically allowing the user to see the most popular items first.

However! When I attempted to use it in a Value List, it said that it would not work as the field could not be Indexed.... Any way around this?

Edited November 24, 2005 by Guest

[Ender]

I think you'd need to script the update of the counts, setting a regular number field.