You'll need a table, that has records containing the sport & organization. Relate it back to your current table by [Field 1 = Sport]. Then, base the second value list on this table, using the organization as the primary field, and basing it on related records by Field 1.
I have created a new table that now has a record for each sport and the next level as follows:
is that what you meant?
If so I have then created the relationship between Field 1 and Sport so that they are equal. But how do I make Field 1 a drop down of Sport and then how do I do the organization to be specific to the sport in Field 2?
When defining both value lists, use the 'Use values from field:' option. For the first value list, 'Use values from first field [New Table:Sport]', 'Include all values'.
For the second value list, 'Use values from first field [New Table: Organization]', 'Include only related values starting from: [First Table]'
Make sure your relationship between [First Table] and [New Table] is by the Sport fields.