Get Count of particular field contents

[rlinsurf]

I have two fields: Networks and Servers. There can be many Servers which all belong to the same Network. But no Servers belong to more than one Network. Each record I have looks something like this:

Network  Server

A             a

A             b

B             a

B             b

B             c

C             a

So what I'm trying to find is -- using a Calc field if possible so the data can remain constant, i.e., not dependent on summary layouts -- how many Servers does each Network have? (In this case, A=2, B=3, C=1).

[Genx]

You should have a related structure:

Two Tables:

Network

NetworkID_PK

cn_numberServers

Where cn_numberServers is a calculation field result number = Count(Servers::NetworkID_FK)

Servers

NetworkID_FK

ServerID_PK

[rlinsurf]

I'll try setting it up that way...

Thanks.