Joe,
>Hm, I did some initial reading on DataViews and would be more interested in how they may solve some of the complexities I have been encountering.
>
>I know it sounds amaturish but for the apps I am writting the MS Access model of a combobox selector that NAVIGATES to the particular record (NOT filters or retrieves just the selected record) is valuable.
>
>All the ADO samples I see assume that the combo data is different that the data being presented on the form.
>This is NOT what I am trying to accomplish.
>
>Any additional insights in to better ways to do this with Business Objects and ADO structures (e.g. DataViews, DataRelations) would be most welcomed.
This is a "big picture" question, but wouldn't you prefer to use a DataGrid for navigation? Using a combo box for navigation forces the user to open the combo box and then select an item, while a DataGrid allows them to simply select the item. It also allows you to see more information at a glance.
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