11 Replies Latest reply on Jun 5, 2017 8:57 AM by beverly

    Need to populate a field in a table that gets imported into.

    mikerevans

      Hi all,

       

      Please can you advise.

       

      I have 2 x tables.

       

      "Instruction" and "Instruction_Tasks"

       

      Both are populated daily by an imported file. All is well there.

       

      Take for instance both tables have these fields "BSW_Ref" and "Metro_Ref"

       

      in "Instruction", "BSW_Ref" is automatically generated sequentially. Both tables have a "Metro_Ref" in the data that is imported.

       

      I need to find a way to populate in "Instruction_Tasks" the "BSW_Ref" field with the related data from "Instruction" I assume this will be via the common "Metro_Ref" value.

       

      I have set the "BSW_Ref" field on "Instruction_Tasks" to work via a look-up. It didn't have the desired effect.

       

      Thanks in advance!

       

      Mike