Looking for a way to select from long list of persons. Dropdown list is
not good for very big list. Maybe there is some way to select initial
followed by name - but how to make easily corresponding valuelists
(dynamic, as the persons change)?. And secondly selecting first city
followed by person? Any snappy example would be very much appreciated...

deme_f wrote:
Use a 'clairvoyant' search structure; a global for search string input,
and a calc to based on the global to return a filter upper limit, and a
multi-parameter rel, and a portal.

Plenty of illustrations via google

If you are using FM10, then true clairvoyance is finally practical (how
many pseudo generations is that?) , with a couple of small scripts and
script triggers, each letter typed into the global refreshes the search
result (portal), i.e. a true progressive as you type search result
refresh, while maintaining the cursor position in the search field, it
even works both directions (add, delete character to string). But that
may be getting ahead of where you are at.


g_search
c_search = g_search & "zzz"

assuming target field to search is 'name', and all fields defined as
text fields
rel:
g_search<= name
c_search>= name

portal based on the rel
global on the layout


This, including script triggered, refresh as you type true
clairvoayance, can be built to handle multiple fields as well; partial
strings in both globals, or partial + empty.