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

    Calculation between table

    JillX

      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
          philmodjunk

          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
            JillX

            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
              philmodjunk

              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
                JillX

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

                Thank you!

                • 5. Re: Calculation between table
                  philmodjunk

                  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
                    JillX

                    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
                      JillX

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