Go to Record/Request/Page calculation

[jdenver]

I have the customers ID number stored in a variable, how do I enter this into the calculation field so the new layout displays the customers details.

I've included a pdf of my script.

I'm not even sure if this is the right approach to do this.

Customers.pdf

[bcooney]

I use one of two approaches to navigate from one table to another via a key value.

1. Simply capture the foreign key, as you did in a $var, then Find in the other table.

2. Populate a global field with the key, and use gtrr to nav to the other table.

[jdenver]

I use one of two approaches to navigate from one table to another via a key value.

1. Simply capture the foreign key, as you did in a $var, then Find in the other table.

2. Populate a global field with the key, and use gtrr to nav to the other table.

So my idea won't work?, can you elaborate a little on your approach please.

[comment]

Perhaps you could elaborate on where you are when you populate the variable? It's not quite clear what "tb_recommended" is and how it relates to the Customers table.

[jdenver]

Perhaps you could elaborate on where you are when you populate the variable? It's not quite clear what "tb_recommended" is and how it relates to the Customers table.

Sorry, ill have a go

tb_recommended is a TO of the customers table with a relationship between a recommended field in the customers table.

On a layout, I see the customers details and a recommend field that shows the customer that had referred this customer. Ive turn the recommend field into a button on the layout so when clicking on this field/button the script runs to show all the "referred" customers details.

hope that make sense.

[comment]

I'd suggest you study the Go to Related Record[] script step.

[jdenver]

I'd suggest you study the Go to Related Record[] script step.

Thanks for that, worked it out now was using GTR/R/P instead of GTRR