AnsweredAssumed Answered

Finding related record

Question asked by Eldberg on Aug 18, 2018
Latest reply on Aug 19, 2018 by Eldberg

Looking for s script solution:

 

There are two related tables: PEOPLE and PLACES.

 

In both tables are two text fields which identify a record: AREA and NUMBER.

 

There is also a calculated text field in both tables consisting of ”AREA + NUMBER”. The result will be a unique identifier in both tables. There is only one ”R132” in PEOPLE and only one in PLACES.

 

The relation is set between these calculated fields in the two tables.

 

Suppose I am looking at the record for area R number 132 in the PEOPLE layout. This record is uniquely identified as R132. (All records are visible, no search or sorting has been done.)

 

I now want to see the related information in the PLACES table, in a layout SPOTS which only contains information from the PLACES table.

 

I tried to do this by a script (uncertain about terminology here since my FMPro is in Swedish)

”Go to related record [from table: PLACES; with layout SPOTS.”]

 

This does not seem to work. I get random records from PLACES.

What am I doing wrong?

Outcomes