i have to do a database with a large amount of athletes.
the table would be Name , age, but then the other fields will vary and some athletes wont have an entry..eg some athletes have had 15 or more events and some only three... i need to put the event details in for each athlete eg put 1st run, and then under that ''where they came", the time they ran, how many runners they ran against, the date etc. How could i set this table up??