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, 20214 yr by Slater

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, 20214 yr by comment

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!