Forums

Hi all!

Alright, so I'm totally new to all this. But here is the scenario:

I have a group of swimmers that need to register for a swim meet. The swim meet has many events, but not all swimmers will swim all events. At the moment, I'm stuck here: the swimmer can save their details (age, gender, dob etc.) and have the option to enter only one event. How would I give the swimmer the option to "add another" event, if they wish - or submit the completed entry?

Obviously, the swimmer must enter at least one event. The swimmer must type the event name (I do not wish to create a dropdown for every upcoming gala).

Any guidance would be great! Still bashing it all out in my head and doing some crash trial and error techniques.

Sincerely,

Hi hambone,

you need to have 2 tables, swimmers table and events tables, events table will have a swimmer id field which points to the primary key of the swimmers table!

Cheers
MAx