Take The Flex Link Challenge

[Tom_Mills]

In my report writing I try to minimize scans whenever possible. In prior versions, I will even do 3 lookups to check for 3 possible values in a field rather than do a scan and handle the results.____I was hoping Flexlink would solve this problem by allowing us the use of Case or IIF functions. But they are not available. For example if you wanted to check field MM in the related file for the values "A","B" or "C" You could do: ____CASE(MM,"A","Y","B","Y","C","Y","N")____On the lookup field side you^d have a "Y".____So.... Am I missing something here? Is there a way hidden within Flexlink to do what I want?__

[kfleming]

You could create 3 Flexlink lookup relations to get there.____Kathleen

[Tom_Mills_(Guest)]

Changing 3 exact normal lookups to 3 flexlink lookups was not exactly what I was looking for. :>)