I've set up a database where players of a team and the goals they scored are stored. On every player record all matches the team played are shown (from another db). Besides each matche I have a (repeating) field Goals where I put the number of goals the particular player scored in that particular match. Besides that I have a field called "Total amount of goals". In that field I want the total number of goals scored by that player in all matches played. This is the total of the (repeating) field Goals.
I defined the field Total amount of goals as follows:
Field name: Total amount of goals
Options / comments: Indexed, = Count Goals
Thing is that the number of games the particular player has scored in are counted, not the number of goals.
Can someone point out what I am doing wrong?
More about my db and the reason I use a repeating field here, can be found in this Insert one db into another. Help needed..