Do you want to see this in table 2 then?
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.
What if I only have one value in field 1?
I tried with fielda+table1::field1 it did not work
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.
COULD YOU PLEASE LIST AN EXAMPLE FOR A VALID RELATIONSHIP BETWEEN THOSE TWO TABLES?
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.
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.
I got it, thank you very much for your help!