wedgeman

Setting data in Related Table's field by script

Discussion created by wedgeman on Jun 12, 2018
Latest reply on Jun 12, 2018 by Karen

Pretty simple database here..

Am having a bit of a challenge and not sure what's causing the issue.

 

I'm sitting on a "parent" table layout, where I have an array of several hundred buttons.  each button is object named (a1, a2, a3, a4, etc -- all the way up to t20)..  (yes this sounds ridiculous, but that's what it is)....

 

So each button hits the same script -  'setbyfieldmatch', which is simply "set Field by Name ["child::" & Get(ActiveLayoutObjectName); "1"]

 

The related record exists at the needed point in time.

I've verified that the field relationships match; I can put a portal on the same page and watch the related fields.


However, the script doesn't want to reach thru that portal and set that field.

What am I doing wrong?  I thought I could create a field match via this method - am I asleep??

Outcomes