I've got a list of people, and they participate in a list of activities. So I have a table for each of these activities.
Here is an example of what the data would look like for each of these tables
tblPeople: (PersonID, Name, Address, ...)
tblActivity: (ActivityID, Name, Date, ...)
Now my...