Discussions

 View Only

Getting a field from another table-long explanation!

  • 1.  Getting a field from another table-long explanation!

    Posted 13 days ago
    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
    ------------------------------