I think I need a calculation for this but which?

[clairetalk]

Hi,

I'm pretty new at a lot of the concepts in FileMaker Pro. I have a database where I track calls and clients. The main table is calls and the clients are in another table. They're related by an id. I'm trying to put a summary field of the total amount of calls each client has on the calls page so I can easily just see how much each person has made. It's got to be a really simple answer, but I don't see anything in summary or calculation that will do just one set of records without doing a find. Thanks

[comment]

Define a calculation field in the Clients table (result is Number) =

Count ( Calls::ClientID )

You could also use a summary field in the Calls table, but this works better in later versions.

[jaydonne]

I'm trying to put a summary field of the total amount of calls each client has

Try putting a calculation field in the clients table with "Count ( calls::id )". That should do it.