How can I use an indirect relationship?

[dtrusty]

Hi,

I have a set of three tables: A, B, and C.

In A there is a portal showing a relationship between A and B.

There is also a defined relationship between B and C.

When I am in table A, I can easily create a button to "go to related record"

to table B. The table B is displayed nicely.

However, I really want to go to the related record in table C, based upon the

current value in table B (just looked-up in the previous step).

Is there a way to do this?

Thanks in advance!!

David

[Chuck]

Assumptions: B is related to C based on a text field called CID. If this field is a number field then make the global field below a global number field.

Create global text field in A called gCID. Create a relationship from A to C with gCID as the local match field and CID as the foreign match field.

Create the following script, Go to C:

Set Field [ gCID, CID ]

Go to Related Record [ C_gCID_CID ]

Chuck