About Step 2

In Step 2, you will learn how to:

• Use more than one recordset in the same record view.
  
  
• Fill a combo box from a recordset.
  
  
• Use a recordset filter (CRecordset::m_strFilter).
  
  
• Sort a recordset (CRecordset::m_strSort).
  
  
• Use recordset parameters.
  
  
• Refresh a recordset by calling the CRecordset::Requery member function — a common task if you use filters and parameters.

Suggested Reading in the Microsoft Foundation Class Reference

• CRecordset::m_strFilter
  
  
• CRecordset::m_strSort
  
  
• CRecordset::Requery

Step 2 illustrates using two recordsets in one record view by implementing a second recordset for the Course table, which is used to fill a combo box in the CSectionForm view. In this way, the CSectionForm view has a primary association with the CSectionSet recordset — the form shows one record from CSectionSet — while the combo box is associated with a second recordset, CCourseSet.

This step changes the CSectionSet recordset so it selects only the available class sections for a single course name, rather than selecting all class sections for all courses. You’ll change the Course edit control to a combo box control and fill the combo box with all of the course names from the Course table. When the user selects a different course name from the combo box, you’ll requery the Section table to select only those class sections for the course name the user chose.