How to go to related record in related file

[snekkis]

I have a script button inside the portal row. The aim is to open the related file and go to that particular record from that portal row I clicked.

I just get to the first record in that open related file when I do so.

[Anatoli]

The file is already open, because you look at it in portal.

Go to Related Record is the correct script step.

[snekkis]

That worked, thanks!

I had a open file script step, but I'm only half way.

In another portal I have a same script based on a message choice button, but I want to set a field in another layout with the values from the related portal row record.

This is how it looks like. How should it be here? I put go to related record on different places with no luck.

Show Custom Dialog ["..."]

If[status(MessageChoice) =1"]

Go to Related Record ["..."]

Set Field ["...", "... : ..."]

Go to Layout ["..."]

Exit Record/Request

Exit Script

End If

[Anatoli]

The Go to Related Record ["..."]

Set Field ["...", "... : ..."]

doesn't probably relate to the same thing.

The Go to Related Record ["..."] will show record from Related file.

The Set Field ["...", "... :: ..."] will set the field on current record in first file with first related record from relation. It will work if there is 1 to 1 relation. If relation is 1 to many, it will take the first record from many.

In that case you first go to the related record and execute script in related file, which will set the field in first file with value from current record from related file.

HTH

[snekkis]

I feel like i don't catch that. Do you mean that I have to make the script in the related file and Perform external script from the first file.

That was to much steam for my brain.

[Anatoli]

Exactly. Do the script in related file and call that from first/main file.

[snekkis]

I have a problem to get right relation. From A file I go to related record in B file and next step is an external step in the B file related . The step from here is based on a relation from B file to A file, as far as I understand. It is only one step:

Set Field["A file Relation: A file field", "..."]

What I trouble around with is, I want this step to set in the current/original record in A file, but it must be a 1 to 1 relation from B to A, as I understand. Isn't it? How do I do that?

[snekkis]

Something weird here! If the Go to Related Record step is not alone, it will not work? I try other steps together and I only get the first record of the related file, but alone it works.

I try to figure this out, but I really can not see how this should work. I'm I trying to make a function that doesn't excist?

Please anyone?

[Fitch]

Maybe it would be less confusing if you set the data you need into a global field, either a global in file A or B, it doesn't matter. Then you can can pass the data in that global on to wherever it needs to go.

Or, you can put the I.D. of the record in A or B into a global, then make a relationship based on that (this only works when the global is on the LEFT side of the relationship).

[snekkis]

Yeah, the global field thinking did it. Now it made sense to me what Anatoli said earlier. Its just me who messed it up, I guess.

Thanks to both of you!