OK I've been using the FilterValues Function as
Field E = FilterValues (Field A; ValueListItems ( Get ( FileName ) ; "List Field D") )
And this worked great up untill I was no longer able to keep Field D = List(List(Test 2::Field B);List(Test 2::Field C)) -That made up the Value List "List Field D"- As an indexed field.
Now I figured I would just do this:
FilterValues ( Field A; Field D) but that returns all empty record so I tried FilterValues ( Field A; Field B) and FilterValues ( Field A; Field C) and it was the same result, just a list of empty cells when there are clear matches beween the fields.
Does anyone know how to get this to work.