I am trying to keep track of records for a very popular game, very similar to bwoling.
There are 4 contestants. (you can see their names and pics in table ‘participantes’)
There are, let’s call it ‘rounds’ where every player throws the ball and we need to track the numbers of ‘pines’ down. done in table ‘palos tumbados’ table
you can see these numbers linked in the ‘palos tumbados’ (pines down) column. in there you will see the score for each round. pending attempts are represented with ‘ceros’ on this field.
no special formula is being used, just the option of multiple records for linked table.
The problem is that I havent figured out a way to sum all the values in the column for ‘palos tumbados’
Forum rules wouldnt let me attach images nor links to better explain myself.