AnsweredAssumed Answered

Script set value in Table B field X equal to Table A field Y for single matching related record

Question asked by boydcrow on Nov 14, 2011
Latest reply on Nov 17, 2011 by boydcrow

Title

Script set value in Table B field X equal to Table A field Y for single matching related record

Post

Without leaving my current layout based on Table A, I would like to use a script to find the single related record in Table B, then set the value of Field X in Table B to be the same as Field Y in table A.  

The tables are related one-to-one so that Field K in Table A matches only one record in Table B, where Field L in Table B has the same value.

Ideally I would still be in the same layout at the end of the script.

I've looked at numerous examples of Perform Find and Set Field but haven't been able to figure it out.

Any ideas?

Outcomes