Storing relationship information of two dynamic-sized databases

Hi all,

I have a database/relationships scenario that I’m not really sure on how to implement. I hope that somebody might be able to help me out.

I have a list of club members in a database. Each record in the database will correspond to a website user, and a link will be established based on the user’s email address so that users can see information specific to them. This much I have already achieved and it’s working perfectly.

My club requires that members attend a certain number of events each year, and I’d like to be able to display to members how many and which events they have attended throughout the year.

Here’s my problem: The number of members in the club is large and dynamic, as is the potential number of events each year. Because of this, I don’t want my members database to need a column for every event, and I don’t want my events database to have a column for every member.

How can I design my databases to be able to store and display this information?

So have you understood how to store it?