The input will change on every event so does this just format the field to mins:secs.hundreths of secs?

Every time the person swims on the clock this will be recorded into the database in the events table per distance and stroke.

The idea then will be another table holding the swimmers PB's will be compared with the event times on update and if the time is faster the PB table will be updated.

Hope this makes sense? So the issue is inputting the swim time in the correct format. The time will not be constant as this depending on distance and stroke but the inputted time will be the format evrytime.

If I can make this work it will help the coaches look at the PB's so the swimmer can be assigned to the right training group and also help the coaches submit swimmers and times to new individual or group events!

The buzz word here is trend analyses. Just need to format a field to enter the correct time format!

Thanks