AnsweredAssumed Answered

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

Question asked by mikerevans on Jun 5, 2017
Latest reply on Jun 5, 2017 by beverly

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!