Self-Join Relationship To Display Subset Of Data

[Woodnote]

Hi,

I've created a self-join relationship so that I can use a portal on a layout of the current table to display a subset of records in the current table...

I can view the subset of records successfully, but I want to be able to navigate to the record displayed through the portal by clicking on it and have it display in the current layout. I'm trying to use the GTRR option (which may be the wrong way to do it) to navigate the subset of records displayed through the portal but after setting up the button, when I click the GTRR button nothing happens...any thoughts? I'm basically trying to make a simple Nav panel that allows me to navigate through a subset of records associated with a table.

Any thoughts on what I'm doing wrong? I'm pretty sure I've just missed a setting or something...

thanks so much,

[bruceR]

There is nothing wrong in principle with what you are doing; so there must be an error with the detail of exactly what GTRR table occurrence you are using. If the table is Contacts, and the portal uses relationship "Contacts_Filtered" you should be doing GTRR Contacts_Filtered.

[Ron Cates]

I want to be able to navigate to the record displayed through the portal by clicking on it and have it display in the current layout.

This sounds to me like you have a layout with a portal and perhaps next to the portal some record details. The record details shown are determined by which record you have selected in the portal. Is this what you are looking for or am I reading it wrong?

[Søren Dyhr]

when I click the GTRR button nothing happens...any thoughts?

If it's the very same record in the portal would it seem like nothing happens at all ... even though! But lets take a look on the build of the keying ... a found set is wrapped via a custom function or how?

--sd

[Woodnote]

There is nothing wrong in principle with what you are doing; so there must be an error with the detail of exactly what GTRR table occurrence you are using. If the table is Contacts, and the portal uses relationship "Contacts_Filtered" you should be doing GTRR Contacts_Filtered.

you were absolutely right! I had just set the wrong table. Thanks so much!

[frankb3]

Good morning. I'm new to self-joining relationships. I'm glad I found this post because I'm trying to do something similar. I have an order entry table that contains thousands of orders. Client data is pulled for each by it's customer number. I want to have a portal on the order entry table that displays a sub-set of all orders by that client.

Can anyone help me out with how to best accomplish this?

Thanks,

Frank