script to perform find in one layout with a value from another
I have two layouts (showing data from two different tables), they are connected by a field called connection_ID. "Table 2" has several records for every connection_ID value in "table 1".
How can I create a script that, when you start in "layout 1", goes to "layout 2" and finds all the records that has the connection_ID value that the record in "layout 1" I just looked at?
I almost get it to work (I think). I have a script that goes to "layout 2" and enters find mode. But when it should fill out the field (by using Set field) it says not a valued data entry... It seems that it does not like when I choose the Calculated results to be the value of the connection_ID field in "layout 1"... what am I doing wrong?