Skip to main content
Question

Getting a field from another table-long explanation!

  • May 12, 2022 4:27 AM UTC
  • 0 replies
  • 87 views

Forum|alt.badge.img+11
TABLE 1 :_DBID_COPY_OF_NEW_BUDGETS
TABLE 2:_DBID_HOUSES

TABLE 1 FIELD :[GM %.TOTAL JOB]  - FIELD ID: 426
TABLE 2 FIELD:[GM %.TOTAL JOB]  - FIELD ID: 3645
I would like for this to automatically happen: 
DESIRED RESULT= FIELD 3645 = FIELD 426

The tables are related and I have a report link that shows this info.  However, I want the value from FIELD ID 426 to populate TO FIELD ID 3645.  I do not want to have to click the ADD COPY OF NEW BUDGETS button because I already have a pipeline set up to CREATE NEW RECORD in COPY OF NEW BUDGETS table that "creates the new budget...triggered by a field in the HOUSES table; the value in FIELD 426 populates at the time the record is created in COPY OF NEW BUDGETS table.

I did find this formula, but it does not work:
[ADD MARGINS]formula field :
ToText(GetFieldValues(GetRecords("{426.EX.'" & [GM %.TOTAL JOB] & "'}", [_DBID_COPY_OF_NEW_BUDGETS]),426))

thank you


 


------------------------------
BuildPro
------------------------------
This topic has been closed for replies.