Self Portal

[mikemccloskey]

I have a DB that has, let's say, 10 records. I would like to create a portal in that same file that lists a particular field of each of those records within that file, so that I can have a clickable list. While viewing record 3, I can see the list,click and be taken to record 8, etc.

I have tried creating a self relationship on a global file to no avail. Is this possible?

Thanks

[LiveOak]

Yes it is possible and quite easy. Create a field:

One (calculation, number, indexed) = 1

Create a relationship with the same file matching One <--->One. Place a portal on your layout using this relationship and fields from this relationship.

Define a script with one step:

Go to Related Record () <--- Select your new self relationship.

Attach this script to a button within a row of your portal.

That's it. Clicking on the button will take you to the record clicked on.

-bd

[mikemccloskey]

Thanks so much. Problem solved. What is the logic behid "One"=1?

[LiveOak]

It is a valid relationship that matches all the records in a file. We used to use it to connect two files for use in passing global fields. We now learn that an invalid relationship is better for that task as it doesn't pull down a list of records from FM Server to FM Client, as there are not matches. It still allows access of globals from the related file.

-bd