Looks like a case for a join table linking period, sport and leader. In each period each leader can only be in one place (eg. John/Volleyball), but each sport can be running in more than one place (eg. Volleyball with John, Rodger and Sam).
But what is it with Patty? She seems to be assigned to herself!
LOL, Ooops Patty has her own activity.
Thank you for your suggestion. I did some research on join fields and see how that could be part of the solution.
How do I join them all?
I the top Entry Section there are a total 6 fields that need to be searched to see if they have the user name - then IF the user name is one of the Activity Leaders, show that Activity in the Leader's schedule on the second page.
Could I please get some more detailed instructions?