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!

 

Mike

Outcomes