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:
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:
In this image, it is clear that there is a matching record in the TMNotes table:
Any idea why FileMaker would not be able to see that there is a matching record in the table