Changing a Field Based on a Reltionship

Question

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
------------------------------

markshnier__you · Answer

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 · Answer

They are all in the same table. I am relating one contract to another.------------------------------Brett Hanna------------------------------

bretthanna · Answer

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 · Answer

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 MartinezCommunity Marketing ManagerQuick Base------------------------------

bretthanna · Answer

Yes, just one table. &nbsp; I want to pull data from the amended contract to the amending contract. The existing to the new one. &nbsp; I did not know you could set up a relationship in the table. That would solve my other issue I think. &nbsp; Thanks, &nbsp; Brett Hanna 805-796-1530 &nbsp; This email may contain material that is confidential and/or proprietary for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you  are not the intended recipient, please contact the sender and delete all copies. &nbsp; ------Original Message------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 MartinezCommunity Marketing ManagerQuick Base------------------------------

Forum Discussion

Changing a Field Based on a Reltionship

5 Replies

Related Content

Snapshot Fields

Historical Date Change Tracking

Changing/setting record owner

Fire changes in a user field -- use a surrogate field?

Trigger RULE is there is a change in an attachment field