Hi Everyone this is my first post here, so hoping I get it right.
I want to create a "Targets db" but as we deal in the running events industry I need to record the runner and the race for each "run" the runner does. Here is an example
Runner = John Smith
Race= New York Marathon 2017
Race= Chicago Marathon 2016
Race= London Marathon 2013
So how can I have one record for John Smith, which then shows that he did the above 3 races?
Any pointers are greatly appreciated.