Go To Related Record, going to the wrong Table! (ie wrong direction)

[Slater]

Solved! Can't see how to delete this post so ...

I had thought that "Go To Related Record From" mean the records that you were going From ... turns out it's the records that you're going To!

😳 ✌️ 🥳

 

 

Hi Everyone,

Hope you can help as I've been banging my head against this one for over an hour, and I just can't figure it out!

(I'm on FMP 16)

I have two tables: People & Pictures

They're related by a relationship called People_Pics_Relationship, and in that

People::ID_Person = Pictures::ID_Person

I have a layout called "Pics" based on this relationship People_Pics_Relationship, filled with fields the Pictures Table, and a script that says:

Go To Related Records: related record from: Pics, show only related records, match all in current found set.

So when I run that script in a layout based on the People Table, it takes me to all the related records from Pictures Table, 

but when I run that script in a layout based on the Pictures Table, nothing happens. It's like it will go in the direction that I don't want, but won't go in the direction that I do want! Can someone help point out what I'm doing wrong, as I guess it's something really simple, but I just can't figure it out! I'm guessing that the layout is based in the People Table somehow, rather than the Pictures Table, but I can't figure out how to switch things around.

Many thanks

 

 

Edited March 22, 2021 by Slater

[comment]

9 minutes ago, Slater said:

when I run that script in a layout based on the Pictures Table, nothing happens

Not sure what exactly you expect to happen. The GTRR script step has a direction - or more correctly, a target table: in your example, it goes to related records in the Pictures table. If you are in a layout of the Pictures table, then there are no related records in the Pictures table, and the step does nothing. 

 

Edited March 22, 2021 by comment

[Slater]

Thanks Comment, much obliged for your response.

Yeah, for the life of me I was trying to make the layout be 'based' in the Pictures Table, but I could only base the layout in a relationship (ie Show Records From: in the layout set up) but I just couldn't get that to work, it was always via a relationship.

I realised the GTRR had a direction, and that my script was going in the wrong direction. Because of the wording in the GTRR script saying "Go To Related Record From" I never played with that as it seemed sensible that this was listing the Table that I was going from. Turns out that if I set "Go To Related Record From" to the Table that I would like to go TO, then it works. That was what was throwing me, if it had said "Go To Related Record TO" I would have figured it out immediately!