To get you going and give you some experience, I suggest you do it this way to begin with. You can easily switch over to another method later without changing your table structure in any way.
First, create a query to select all Baseball records from your table. Use the Query Wizard to select all the fields you need. When you are prompted about opening or modifying the design, choose Modify.
The query grid appears. In the Criteria row under SportType, enter the word Baseball. If you run this query, it should only show you records relating to baseball.
While the records are displayed, click the arrow next to the New Object button on the toolbar.
Select AutoForm from the drop down list. A new form is created containing only your Baseball records.
A similar method can be used to create a form for Soccer Records, using the appropriate word in the criteria row of course.
Yoyu can use these forms to enter new records for the sport concerned. Even though the records are entered into different forms, they are stored in the same table. If you want to enter records from both sports at any one time, use a query based on your table, but don't enter anything in the criteria row. Your Baseball and Soccer forms can then be used to separate the records at will.
Post again when you have finished this set of procedures and I will show you how to alter the forms to make them more foolproof.
