GTRR... how?

[Kmpuz]

In one layout I create bank accounts. That information is copied into one new record from the main layout. In that main layout I have a portal with the names of the accounts. The relationship between those tables is marked "X", so every account appears on that portal. On the main layout I have another portal with the bank statement and balancefrom the transactions layout.

The problem is when I want to navigate from the portal with the account names on it.

Maybe is too basic, but I can't find a way to make it work with the "Go to related record".

Any ideas of what I'm doing wrong? (or not doing right?)

Thanks from Mexico

[Vaughan]

It's probably working: look to see whether the record numbner is changing.

What you might need to do is to GTRR then change to a layout that shows the account details.

[Kmpuz]

In my script "Go to Related Record" Options, "Get related record from:" I use the table "AccNames", so far so good. I want to stay in the same layout, just change record. In "Show record using layout:" I have as an option , but it doesn't work. The name of the Layout doesn't appear as an option.

[Vaughan]

Ok try this: have the status area showing. Go to the first record. Click on one of the portal rows. See if the record number has changed.

[Kmpuz]

Nope... Every record has the name of the account an it doesn't change. I been trying all day long. Maybe is something in the relationship.

The layout "Movimientos" is where the portals are. In "Cuentas" is where as now I create accounts.

As they say, an image is worth a thousand words. Hope this example makes myself clear.

Thanks in advance

DineroA_Copy.fp7.zip

[David Jondreau]

In the script step, Go To Current Record[], you need to specify the layout that needs to be shown.

The default is the current layout, even if that layout is based on another table and can't access the data you're trying to navigate to. You should have been getting an error message along those lines.

[Kmpuz]

I created a new field for accounts, a serial number starting from 1. Then placed that field in the portal making invisible the number and used the script "Go to Record/Request/Page". Now it works. Still I don't like the solution.

[David Jondreau]

In the file you posted, all you need to do is specify the layout.

[Kmpuz]

I tried, but I get a message telling me it can't get the layout.

[David Jondreau]

That doesn't make sense. You shouldn't get any message at all. In the GTRR script step, you should have a list of layouts which are based on the table you're navigating to. The layout is there or it isn't and if it isn't, you're mistaken about the table you want to go to.