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,