Multiple fields may contain same info. How do I collate?
I have a database for an after-school program in which the kids can choose ten different activities from a list of about 50. Any given activity could appear in any of the ten fields (choices 1-10).
I need to be able to collate all the fields at once to determine how many kids want each activity and also which kids want which activity but I have no idea how to do this. I am a novice with relational databases and could use some help.