Some help here

Kruna hi kruna.

I have a Formula on trigger after update for GF and GC and work perfect but needfor each teams the points, on Equipos table

Kruna Hi Kruna

This Formula SUM the same for all Teams need, need for each team.

Kruna 

Example this game GF 3 gosls  and GC 1 goal  win the Young Boy and gain 3 points need toplace the 3 point on Teams table on Young Boy Team but if win Arsena need to place the 3 point to Arsensl on Teams table

Kruna yes

Fred 

Hi Fred.

i have the relationship between Teams (Equipos)  to Games (Partidos)

Fred 

yes Fred, I'm doing something wrong

Fred 

sum((select Partidos).'Ptos L') + sum((select Partidos).'Ptos V')

but this plase the same result in all game, in the Equipos need the points for each teams.

_______________

In field GF and GC I place this code and works ok. 

Team 1. 2 goals Team 2 0 goals / Team 1 have 3 points 

Team 1. 2 goals Team 2 2  goals / Each Team  have 1 points 

Team 1. 0 goals Team 2 2 goals / Team 2 have 3 points 

if GF = null or GC = null then
    'Ptos L' := null;
    'Ptos V' := null
else
    if GF > GC then
        'Ptos L' := 3;
        'Ptos V' := 0
    else
        if GF < GC then
            'Ptos L' := 0;
            'Ptos V' := 3
        else
            'Ptos L' := 1;
            'Ptos V' := 1
        end
    end
end

Fred 

I'm not getting the idea, I have the gross at a million.  sorry

Fred Hi Fred I explained to bad very sorry. Is more complicate.

To update the teams' table with the points earned from the matches, I need  use a script that loops through all the matches, evaluates the result, and assigns the appropriate points to each team.

I have a Teams table and a Matches table, where:

The Matches table includes the following fields: EquipoLocal_> (link to the Teams table), EquipoVisitante_> (link to the Teams table), GolesF, GolesC ,PtosL (3 for a win, 1 for a draw, 0 for a loss) PtosV (3 for a win, 1 for a draw, 0 for a loss).

The Teams table includes a field: TotalPuntos, TotalGF, TotalGC (fields that will sum the points from each match).

Fred 

Ok Fred, on Table Patidos I place the Goals for each macht, then I need to sum all the poins and goals  the on table Equipos for each table. Now place it manually.

Fred 

You have to manually enter the goals scored by each team Yes in table Partidos when the game finish I place de score GF and GC and depends on that result place 3 if win Local 1 and 0 to Visitor if is Tie 1 for both teams and if the visitor win 3 point to visitor and 0 to local.

That will run the trigger after update to update puntos. Yes and work perfect.

Then you need to modify the code in Equipos to sum GF, GC and Puntos. Yes one team can play 8  games minimun and 17 maximun. For each teams need summ all GG, GC and points.

exmple is one team play 8 games if win 4 tie 2 and lost 2 the finsl points 14 points points.