[marcusd]

I am trying to write a saved search formula that runs on a parent record and will check a set of child records and see if one exists with a certain field value. If one does, I want to filter out the parent record from my results. I have tried CASE WHEN and DECODE with no luck. The parent record that I am trying to filter out is still in the results. In this particular case, there were 5 child records, one matched my criteria and the parent record was repeated in the results 4 times.

Any help would be appreciated.

Marcus
This is a cached copy. Click here to see the original post.

[Author]

Posts