Getting a field from another table-long explanation!

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