I have created a SDI app with MFC wizard and included a recordset. Now 2 questions 1. How do I create another view and recordset from a different set of database tables and CHANGE to that view. (I can create te view and set but don''t know how to change to the view.) 2. Can I create multiple recordsets and use the same view but get data from all the sets. if so, how do I link all that together after creating the recordset with classwizard?? Thanks, and sorry for puttiong this on gamedev.net but This seems to be were all the help can be found. thanx ppl