Forum Discussion

SylvesterOkelek's avatar
SylvesterOkelek
Qrew Trainee
5 years ago

Help with field value lookup.


I have two tables {Budget} and {Account Distributions}. The relationship is Each Budget has many Account Distributions.
I am trying to make the Total sum of the field {Amount} (highlighted in orange color)
to always be reflected in the field {Obligated Amount} (highlighted in blue color).
Please any help from the experts will be appreciated.

Thanks,
Sylvester.
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    np,
    just go to the Relationship and on the left side there will be a button to create a summary field. Then delete your existing field and use the auto calculated one instead.  Check where the old field is used first, by looking at the "Usage" tab on the field properties and replace the old field with the new one.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • SylvesterOkelek's avatar
      SylvesterOkelek
      Qrew Trainee
      5 years ago

      Wow! Works like a charm! 

      Thanks Mark. 



      ------------------------------
      Sylvester Okeleke
      ------------------------------