I have one important question: 
Can I add some string or other value to the lefthandside of  a
relationship in order to get a relation to all records? The problem is
tricky as the relation in question is based on name and not a constant
like "1". 
Could I perhaps make a constant relation and build 2 popups from each
relation and then somehow set a third popup to the values from either of
those,  if the filter field contains a value? Any ideas on how to do
value list source switching like that? Just get me started....

Background: I have built a relationship based on the value of the Global
"NameSearch" in my contacts.fp5 DB to a NameIndex field, storing on
multiple lines the 1st, 1st and 2nd, and so on, character from the
namefield value***, both the latter in my Individuals.fp5 DB. 
If the user write a string I can then choose the name from a dynamic
pop-uplist, which sets the connected field "related_ID" to the ID of the
connected Individual. 
However, I'd like all names to display if the user types nothing, so I
thought that adding "*" (sans "") as a default value would do the trick,
but that gives no results. Does putting characters like "*" only work in
Finds? Is what I want totally impossible?

 

I wrote:

> I have one important question: 
> Can I add some string or other value to the lefthandside of  a
> relationship in order to get a relation to all records? The problem is
> tricky as the relation in question is based on name and not a constant
> like "1". 
> Could I perhaps make a constant relation and build 2 popups from each
> relation and then somehow set a third popup to the values from either of
> those,  if the filter field contains a value? Any ideas on how to do
> value list source switching like that? Just get me started....

I realized I could make a value list "C" from a local field and make
that field a conditional calculation that by the ValueListItems function
took values from either one of these lists "A and B", built on 2
separate relations. One being a constant so I get all names and the
other only related records by my filter string. The absence of a filter
string value would choose the constantbased value list.

However, I also need to display a second value in my popup. Pretty
pointless otherwise. I have "ID + Name" in both lists. How do I make the
second value carry over to display in the conditional list?