Update fields from another form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a results database with multiple tables (Best Results & Competition).
One table (Best Results) holds records of best event results attended per
athlete these results change each time the athlete competes in the event. The
second table Competition hold records of all events results per competition
for each athlete. The Best Results records need to be updated from the
Competition table after the new record has been entered.

My problem is that Im not sure how to go about this, any help would be
greatly appreciated.
 
By keeping a "Best Results" table, you guarantee that you have to keep it
updated. Another approach would be to build a query that inspects an "All
Results" table and finds the "best". This would be dynamic, and you'd NEVER
have to update a separate table.

Or have I misunderstood what you are trying to do?
 
Jeff,

Thanks you did not misunderstand me, I wrote it wrong, what i should have
mentioned was that the best results for each athlete changes as they do that
event, even if they do not better the time, it resets to the current result
for them to try and better the next time they do that event which may not be
for another three week or so.

I would like to update the best results table at the end of entering the
data in the competition table for all athletes.

Any further help in this matter would be greatly appreciated.
 
So, let me restate...

Don't record the "current best". Look it up with a query.

If you are recording each, say, month's performance, you can create a query
that returns the Max() date/time for each athlete (a Totals query, Grouped
By Athlete, Max of [YourDateField]).
 
Back
Top