How would I set this up

[NZ_Kiwis]

I want to have a record for each persona in my training group for each day over a period of time.

So for example I might say we're recording our daily figures from 01Sep - 15 Oct so each day in between this I have to enter a figure for each of my 10 athletes.

Some days might be their 'day off' some might be when they are 'sick' or doing 'weight work' so i need to be able to add execptions to each day.

On the days I need to record a number of times etc so there wouldn't just been one field for this so perhap that's it's down table.

What I was thinking was

Athletes Table
ID | Name |

Days Table
ID | Date | State (value for working, sick, weights etc)

Results Table
ID | Athlete ID | Day ID | Result 1 | Result 2 Result 3 |

WOuld that be okay?

[NZ_Kiwis]

Anyone?

[dagon]

looks fine, if result (1-3) is fixed if there could be 1-100 then you should just have result and result_type, result_type being 1-100 with result being the value, then there is one entry per athlete per day per result_type

[NZ_Kiwis]

and how can you tell if a day has passed and results should be entered?