sum from selected field on another table

[sirtemplar]

hi. i do not know if my subject is correct, however this is what i am trying to do.

i have a database with two tables. table 1 contains:

field1 (text)

field2 (number)

on field two there are values of 1500. what i want to do is put the some all the values with 1500 and put it on a field on table 2. how fo i do this?

[Raybaudi]

Hi

1) make a global number field in table2

2) make a relationship

Table1::field2 = Table2::gNumberField

3) make a calc field in table2:

Sum ( Table1::field2 )

From now, if you enter some number ( for example 1500 ) into gNumberField, the calc field will give you the sum of all related field2