"I couldn't get my head around it" is also cloudy as it doesn't tell us where you are having trouble setting this up. I suggest that you try to get this to work and then report back what you did and what results that you got.
I will point out one small item of difference: Most uses of this method have portals to different tables. You've indicated that these portals are to the SAME table. That can still work as long as you base your portals two different table occurrences that refer to this one table and that would be my best guess, but it's only a guess on where you are having trouble with this.
See this link if "table occurrence" is an unfamiliar term: Tutorial: What are Table Occurrences?
Not sure why you need two portals. Surely you can have a single portal and a self join. Then somewhere in your portal you have a more button which takes you to the related record based on the portal table. E.g if you have a layout called wine details based on a table called wine. Then you set up an instance of wine called Wine records so that:
Wine::Wine id x Wine Records:: Wine id
and then you need to go to the related record from Wine Records. thanks
Phil, Ill digest and report back. This looks to be the process I need to understand better.
Kaps, yes. The way you describe it is how Ive always structured things in the past. That works because I can go to the related record in a separate layout. It fails here because its in the same layout. I may go this route again as there is so much information its actually overcrowding the layout anyway, which would be the smarter solution.
Steve, YES! Thats it! I see the self-relationship in the database and I've implemented something similar, but can you elaborate on the button behavior/script that allows the left-pane to populate with the selected record from the right?
Phil's example is exactly how I had it in mind.
Phil's way is actually better. The script does a find, show all sort. But you can always just open up the script and look at it. If you have FM adv, put on the script debugger and go line for line