Use database for events and show sign-ups on website

I am creating a website for a club and I’m trying to make it as easy as possible to create new events (and automatically create pages for them) whenever needed. I have been using dynamic pages to do this, but I have run into a problem.

I’m trying to make it so that site members can sign up for these events within the dynamic page by using “User Input Elements” to create a form for members to fill out with their name and contact information. All of this data goes into one database and the events are in their own separate one. Is it possible for me to just use one database? That would make it much easier as I wouldn’t need to make a new one for each event.

I would also like for all sign-ups to be displayed in a table. When I test this out, they show up right away. However, whenever I leave the page and come back to it, all of the data that was previously in the table is gone. Why is that? How can I create a table to display the database without having them disappear from the table each time I leave the site? (The data stays in the database, just not the site.)

Also, is there a better way to do this?

Thanks.