I´m trying to perform some calculations across related tables, and i don't know why it's not working...
I have a table called "Sectores de Incendio" and another called "Relevamiento de Materiales"
"Sector de Incendio" fields: (among others)
Carga Fuego A
Carga Fuego B
¨Relevamiento de Materiales¨ fields: (among others)
Cargas Calorificas A
Cargas Calorificas B
they are related by a field called "Nombre Sector"
the field Riesgo Sector is defined as the calculation Min ( Relevamiento Materiales::Riesgo Material )
Carga Fuego A is defined as the calculation Sum ( Relevamiento Materiales::Cargas Calorificas A )
Carga Fuego B is defined as the calculation Sum ( Relevamiento Materiales::Cargas Calorificas B )
Neither of does calculation is working and i can´t figure out why!!!
Picture to further clarify: