Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Re: Getting all related records from relationship w/o constants



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? 



<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.