Clicking on records in a portal

[Jenna]

Hi,

On one of my layouts, I have a text field in which you can search for a last name to see if it is already in the database (e.g., you'd type in "Smith"). If the name exists in the database, all occurrences of the name (Mike Smith, Derek Smith, etc.) show up in the portal below the text field. I want the user to be able to click on each name and be taken to that person's record (in my "contact" layout).

Right now, every time you click on a record in the list (if there is more than one name), you are taken to the record that matches the *first*/top name in the portal. (If the list had the following names in the following order--Mike Smith, Derek Smith, Lydia Smith--clicking on each name would take you to Mike Smith's record.)

I thought "Go to related record" might fix this problem, but it didn't. Why does clicking on every name in the list take me to the record associated with the *first* name in the list?

Thank you.

Edited October 30, 2009 by Guest

[Fitch]

Go to related record (GTRR) is the correct script step. My guess is that you have it pointing to a relationship that doesn't match the portal's relationship.

IOW, if your button is saying GTRR (Contacts 1) but your portal is actually based on Contacts 2, the GTRR won't work as expected.

[Jenna]

Dear Fitch,

Yes, I checked to make sure the script and the portal were pulling from the same table, and they are. I have uploaded a sample version of my problem. Would you mind taking a quick look?

If you click on "Add Author," it will take you to a page where you do a search to see if the author's last name has already been entered. If you enter "Smith" in the box, you'll get a list. Try clicking on those names, and you'll see what I mean. I feel like this should be an easy fix, but I'm just not seeing what the problem is!

Thank you a million times!

FMF.fp7.zip

[efen]

You don't need the first goto author layout step.

The goto related record step alone is needed (and this then goes to the layout you need)

You select the record you need before going to the layout to show the record selected

Edited November 2, 2009 by Guest

[Fitch]

IOW, when you go to layout, you've lost the context of the portal, FileMaker does not know at that point what portal row you clicked.

As efen said, remove the first line of the script and simply GTRR.