Forum Discussion

BrettHanna's avatar
BrettHanna
Qrew Member
6 years ago

Changing a Field Based on a Reltionship

I am entering contract information into QB. One of those fields is related contracts for things like amendments. If I enter an amendment, how can I pull data from the original contract and have it populate into the existing agreement I am creating?

------------------------------
Brett
------------------------------

5 Replies

  • Can you describe you two tables and the relationships?  Which is the One and which is the Many.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • BrettHanna's avatar
      BrettHanna
      Qrew Member
      They are all in the same table. I am relating one contract to another.

      ------------------------------
      Brett Hanna
      ------------------------------
    • BrettHanna's avatar
      BrettHanna
      Qrew Member
      I guess the follow up is, can I make them related to each other. It is not a true relationship, I just enter the original contract on the amendment.

      ------------------------------
      Brett Hanna
      ------------------------------
      • EvanMartinez's avatar
        EvanMartinez
        Moderator
        Hi Bret,

        So all of your contracts are in one table and you want to pull data over from one contract to another since they are like a template or because they are related to one another? Do you have a relationship set up relating that table to itself?

        ------------------------------
        Evan Martinez
        Community Marketing Manager
        Quick Base
        ------------------------------