How to calculate number of items in a portal

[Matt Leach]

I had been stumbling on this for a few hours now and figured it was time to ask for help.

I have a database with 2 tables, Clients and Claims

On the Clients layout, there is a portal which is linked to the claims that are associated to that Client.

I also have a field on the Client layout for 'Claim Count' which i was hopeing to use to calculate the number of claims the client has.

How would i go about calculating the number of items from within the portal? Thanks

[bruceR]

Assuming you have a foreign key field in the claims table called "clientID" then:

Count( Claims::clientID)

[Matt Leach]

Assuming you have a foreign key field in the claims table called "clientID" then:

Count( Claims::clientID)

Worked like a charm, i thank you for your time and assistance, it is much appreciated