Multiple events per location Distance tables

[flebber]

I am doing a sports database and would like some advice on table structure. Using access 2007.



I am trying to stop the repetition of "location" in tables. I already have created a location table with LocationID, State and Location Name. What I want to record is that each location will have events at varying distances.

What my aim is, is to record best time, average time by distance at location. So that later I can reference which locations have which distances and if wanted best times per distance or per location.

I am having trouble getting the distance, time and location layout correct though. Since each location has mulitple distances and each distance has different times based on location. Either way its seems to lead me to repeat data. i.e. say for four locations there are six distances and each time is unique but could change.

Or in this case is repetition unavoidable.

[llkhoutx]

Take a look at table relationships. Try drawing a picture of your tables and identifying if they have one to one, one to many, and may to may relationships.