Script set value in Table B field X equal to Table A field Y for single matching related record
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.