
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
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__ --> |