AnsweredAssumed Answered

Question regarding "Relookup Field Contents" Script Step

Question asked by andrewma on Feb 1, 2017
Latest reply on Feb 1, 2017 by philmodjunk

I have one Database with two tables.  Table A and Table B.

Each table has its own layout, and each table will have a different number of records.

 

I have a field in each table that I have created a relationship with, lets call it Field 1.

 

So in Table A    I have Field 2, that is set to be a lookup of its corresponding Field 2 in Table B.

 

 

I have a simple one line script that says the following:

Relookup Field Contents [With Dialog: off; Table A: : Field 1]

 

What I am expecting to happen is to match Field 1 contents from Table A, to the matching record in Table B, then the contents in Field 2 from Table B to be put into Field 2 from Table A.

 

That is not happening,

Outcomes