Go to Related using Value List

[Steve E.]

I've seen this done in a free training workshop at rapid speed (no longer on line, of course), but can't seem to replicate it.

I'd like to use an auto-complete value list to go to the related record(s). For example:

Table 1 has the field "last name."

In the record Header, I'd like to have a "find field" with a value list created from "last name" set on auto-complete.

Ideally, after each letter is typed into the "find field" the current layout will go to the record(s) that is related to the entry in the "find field." I'd even settle for the "Go to Related" script only operating when exiting the "find field," though that wouldn't be as slick.

I've tried using self-join and separate table relationships, and various variations of the value list used in the "find field," but have been unable to get this to work. Can anyone show me (or give me a strong hint) how to set up the combination of the relationship, field IDs (which table they're in), and the value list set up?

[comment]

Why not do a find?

[Steve E.]

Well, yes. I could have a script trigger "perform find" when it exits the field. I did take a quick stab at setting this up so that a "perform find" script trigger would be activated by a key stroke while selecting in the value list by typing more and more of the name until there is only one possibility left. The problem is I don't see a way to enter both enter "find mode" and simultaneously actually enter data. In other words, if a keystroke is used to trigger entering "find mode," that stroke is not entered; i.e. typing "s" will enter "find mode" but not enter "s' in the field. So entering "find mode" would need to be triggered by "OnObjectEnter" and "perform find" would be triggered by exiting the field. With this method, there isn't a continual display of the actual records as the choices in the find field are narrowed. I hope that makes sense. It just seems to me that it would be more elegant if there were a way to either perform a find with each keystroke or have the value list in the find field continually (with each keystroke) performing "Go to Related."

[comment]

Try triggering the script OnObjectModify.

GTRR would be less than optimal choice here, IMHO. A find will work with no additional resources, while GTRR would require adding a relationship and probably a calculation field or two as well - see:

http://www.fmforums.com/forum/showtopic.php?tid/217736/

[Steve E.]

See Link for a simplified example of how I've decided to go about this (using find).