AnsweredAssumed Answered

script to perform find in one layout with a value from another

Question asked by annacaltech on Jun 1, 2009
Latest reply on Jun 1, 2009 by comment_1

Title

script to perform find in one layout with a value from another

Post

Hi,

 

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?

 

Thanks,

anna

Outcomes