MattLeach

GTRR Issues

Discussion created by MattLeach on Sep 4, 2012
Latest reply on Sep 5, 2012 by MattLeach

Im in the process of rebuilding an existing solution and have come across an issue.

 

There are two tables involved which are clients and TMNote which are related by:

 

Clients::_pk_ClientID = TMNotes::_fk_ClientID

 

On the clients layout, i have a button that i have setup using the GTRR script command. Here is full script:

 

script.png

I do have the option selected to Show only related records, Match current record only.

 

When i click the button, a new window opens to the TMNotes layout but all fields have a ? in them even though there is a match:

 

question.png

 

In this image, it is clear that there is a matching record in the TMNotes table:

 

match.png

 

Any idea why FileMaker would not be able to see that there is a matching record in the table

Outcomes