Linda,
>I have 2 drop down lists on a web form. One needs to include all users, the other only those who are marked as approvers. Do I need to create a view for this or can I create a second dataset and somehow reference the data set in the binding properties?
Rather than creating a second DataSet, you can create a second DataTable in the business object's DataSet. For more information, see the MM .NET Dev Guide topic "Working with Multiple DataTables in a DataSet". Take note of the links at the bottom of the section that refer you to topics that show how to bind your UI controls to "secondary" DataTables in your DataSet.
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com