Hi All,

I want to find out if anyone has found an elegant way to filter a smartobject list, excluding entries from another list.

This is much like the Not In filter SQL provides.

I know it is probably possible through the ADO.NET provider, but I need to use an exclusion filter like this in SmartForms to filter a Drop-down control.

Your ideas will be welcomed.

For clarity here is an example:

SmartObject 1:

Animal

Rhino

Elephant

Lion

Cheetah

Hippo

SmartObject 2:

Animal

Lion

Cheetah

Result I'm trying to produce excludes Lion and Cheetah from SmartObject 1, so the results are:

Animal

Rhino

Elephant

Hippo