Calculating Number of Related Fields

[nutthick]

I have two tables, Matches and Goals, with a MatchID relating the two. One of the match layouts needs to display the match details (locations, teams etc.) which is easy, but is also required to display the score. The Goals table holds details of the MatchID, TeamID, Player who scored and the time. I'm assuming I can place a calculation field into the Match table to tell me the number of related records from Goals, but I don't know where to start. Also there is the added complication of Teams. The Match table includes the TeamIDs of the two teams playing, so the calculation needs to know which team scored the goal. Can anyone help?

Thanks

[Søren Dyhr]

Here's a few ideas ...take a look at the attached template!

--sd

Footie.fp7.zip

[nutthick]

Thanks S