Player Draft-Step 2

1. Forms button >> New >> AutoForm:Tabular >>
   Players Without Matching Teams query.
   Click OK.

2. Design View. Select the TeamID control, then
   press Del key.

3. Click the Combo Box tool. Click and drag in the
   Detail section, then release the mouse to start
   the Combo Box Wizard:
   • look up values in a table or query,   Next
   • Teams table,   Next
   • Select TeamID and Nickname fields,   Next
   • Sort on Nickname field,   Next
   • Adjust column width if necessary,   Next
   • Store value in field. Select TeamID field.  
     Next
   • Enter Team as label for combo box.   Finish

4. Select the lable next to the control you just
   created. Press Del key. Point to combo box,
   right click, select Properties. Change name of
   control to TeamID (Other tab >> Name >> TeamID).

5. Properties List for the form >>
   Format tab >> Default View >> Datasheet.

6. Save,   OK