I'd like to supplement the Status area of a layout with an alphabetized list of all the records - in this case, the people in our mailing list. Clicking on a name would take the user to the related record.

I thought I could use a portal with a scripted button, but FMP won't let me create a portal to the table that the layout itself references.

Any suggestions?

Thanks!

Create a self-relationship based on the record id. This will create a second occurrence of the table. Then base your portal on the related TO, and make the portal fields a button that uses the GTRR step based on the new TO.

Edit: I forgot to specify that the relationship should be Cartesian (using the X operator).

Thanks for the reply!

Making the relationship Cartesian did indeed help me make the list in a portal. But for some reason, even though I made the field a button, the script isn't working - that is, clicking on a name in the menu doesn't take me to the related record. Aside from not getting enough sleep, what am I doing wrong?

I'm attaching the file to this post. It's a work in progress, so please forgive the messiness. The portal is on the form names "Browse..." Thanks again!

Cloneforupload.fp7.zip

In your GTTR step, specify the layout to use.

Thank you!

D

Ah. Only now have I popped out for a cafe and understood what you meant...

Gosh - is that poor netiquette?