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.


      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!