I have taken a look at the DataViews section, but it seems to detail how to sort the table rather than filter out entries.

If I have instantiated the object twice, why can I not attach the mmDropDownList to the business object directly.

e.g. oSite and oTempSite are two separate instances of the object and both have pulled different sets of data from the same data table.

I understand the benefit of DataViews in this case, but am still wondering how to get a complete set of data AND a subset using DataViews. The development guide does not talk about filtering the DataView, just sorting.


Orders <<---->Site
Orders <<---->TempSite

oSite = Select * from Site
oTempSite = Select * from Site where not (description like '%Office%)