Coding All Wrong - Pls Help

[Paul]

I designed my database but I'm on of those persons who go
off witha load of ideas - but only one thing stands in
their way - only because my knowledge of VB is very bad.

Its too complicated for me to explain the following
situation, so below is the link to a zipped copy of my
database.

http://www.meista.co.uk/SwimmingClubAdminSys.zip

Please could you take a look at it for me and make a
suggestion and/or make any changes that may help me. Even
better you could make the changes yourself and mail it to
me at (e-mail address removed)

All I want to do is from the "Calculate & Update PBT
(personal best times) button", the computer to find the
required field on the club members table and update the
time if thier results was faster than thier previous best
time.
What I tried to do was to create a variable based on the
Race Type such as stroke and distance (variable ex = FC25)
then find the field on the Members Table.
The Button also calculates the fastest overall event time
in the results form. It is complicated I know. Please
could you make any recommendations or changes if possible.
If you need to ask any more questions reply to this post
and Ill answer very quickly as I'll monitor this post
with every minute of the day. Im so desperate to get this
done.

Thankx

Paul

 

[Sandra Daigle]

Hi Paul,

Having worked with Swimming data (including my own swim club application)
the one recommendation I whole heartedly make is to look at a 3rd Party
Solution. The one we use (and is used by many USAS Teams) is Team Manager by
Hytek: http://www.hy-tekltd.com/. This product already does just about
everything we need in a team management solution.

Regarding your specific question, I don't really recommend storing best
times on the swimmer's record. Since best time is a calculated or derived
value it is best to compute or derive it when needed rather than trying to
catch all the times when the underlying data might change, necessitating a
recalculation.