7 Replies Latest reply on Jun 12, 2012 1:32 PM by JillX

# Calculation between table

### Title

Calculation between table

### Post

I want to use a field value of table A to accomplish calculation with multiple records in field on table B.

It looks like following example,

Table 1:

Field 1

33

Table 2:

Field A

45

56

67

78

89

I want to add 33 to all values in field A from table 2. how can I achieve that?

Thank you!

• ###### 1. Re: Calculation between table

Do you want to see this in table 2 then?

Field A

78    (45 + 33)

89    (56 + 33)

100    (67 + 33)

111    (78 + 33)

122    (89 + 33)

If so and you have a valid relationship between tables 1 and 2, then this calculation field defined in Table 2:

Field A + Table1::Field1

Will produce those results.

• ###### 2. Re: Calculation between table

What if I only have one value in field 1?

I tried with fielda+table1::field1 it did not work

Table 1:

Field 1

33

Table 2:

Field A

45

56

67

78

89

• ###### 3. Re: Calculation between table

Only one value in field1 is what I assumed that you had here as you indicated that you had a one to many relationship from Table 1 to Table 2.

It will work, but note the qualifier: If you have a valid relationship between the two tables.

Please describe the relationship and exactly how you implemented this calculation as it can't be done with an auto-entered calculation, you must use a field of type calculation--not number to get this to work.

• ###### 4. Re: Calculation between table

COULD YOU PLEASE LIST AN EXAMPLE FOR A VALID RELATIONSHIP BETWEEN THOSE TWO TABLES?

Thank you!

• ###### 5. Re: Calculation between table

What relationship have you defined at this time?

I can define any number of valid relationships for this, but have no idea what relationship will work for you. If you describe the relationship that you have at this time, I can tell you whether or not it will work or if a modified relationship will do the job.

PS. All caps posting is the electronic equivalent of shouting at the other person.

• ###### 6. Re: Calculation between table

I'm really sorry. Please forgive me. Thank you for telling me this.

I want to use table1 as a data input table for field1, and apply this value in other tables. No other limits for relationship, anything works.

Thank you!

• ###### 7. Re: Calculation between table

I got it, thank you very much for your help!