Hi,
I have a table called ClassPoints with the following fields in it;
Scenario:
If 3 races [EventName] have been completed and the results was imported already and competitor x [IDNumber] did not enter/partake in this 3 races [EventName] BUT competitor x [IDNumber] enters and completes race 4 in the OR1 class, the following must happen when the race 4 [EventName] results are imported:
All the above happens during the Import process of Race 4 results and all to the same table.
EventName = IDNumber = Class , is the 3 fields that we use to identify the individual records/entries
Question:
Where/how on earth do I start with this . The imports works great, reports work great, but I need the above to work so we can calculate overall race results and season results.
I have a table called ClassPoints with the following fields in it;
- EventName [Race Event Name]
- EventDate [Race Event Date]
- IDNumber [Competitor IDNumber]
- FirstName [Competitor FirstName]
- LastName [Competitor LastName]
- RaceNr [Competitor Race Number]
- Class [Race class entered i.e. OR1, OR2]
- RacePosition [Race result position]
- ClassPoints [Points achieved according to Position]
- DNF [Did not finish race]
- DNS [Did Not Start race]
Scenario:
- Race results are imported after each event is completed
- Each event have multiple competitors per event and each competitor can ride multiple events
If 3 races [EventName] have been completed and the results was imported already and competitor x [IDNumber] did not enter/partake in this 3 races [EventName] BUT competitor x [IDNumber] enters and completes race 4 in the OR1 class, the following must happen when the race 4 [EventName] results are imported:
- System must check current records and "eventname" results already in the table for Competitor x [IDNumber]. If it does not exist in any of the "completed" events already uploaded, then a matching record for this competitor must be created for the races he did not enter and also in the class OR1 of the race 4 he did enter. The DNS field must then be set to Yes to ensure that the true race entries can be identified for that 3 races
- Because this is a series, the competitor x [IDNumber] must be penalised for NOT entering the previous 3 races [EventName] by adding 25 points to the RacePosition field for the previous 3 races HOWEVER NB!!!
- We must count the true race entries per class for race 1 [EventName] and add the 25 to that total entries, same with race 2 and race 3 he did not enter
All the above happens during the Import process of Race 4 results and all to the same table.
EventName = IDNumber = Class , is the 3 fields that we use to identify the individual records/entries
Question:
Where/how on earth do I start with this . The imports works great, reports work great, but I need the above to work so we can calculate overall race results and season results.
Comment