I am working on a sports carnival application to remove the need for complex excel workbooks, as the new person in charge of these events has little excel skills.
While I can add a result record for a heat into the DB that is not an issue, I need to be able to lookup and allocate points based on their time.
The database would look as such:
Result Table
|ID|Name|Squadron_id|event|competition_id|heat|time|heat_position|overall_position|points|
Points table
|ID|position|points_allocated|
1 1st 10
2 2nd 8
3 3rd 6
4 4th 4
5 5th 2
6 6th 1
What I have no idea on how to approach is how to allocate the overall position and the points in the result table.
These will need to be updated as additional results come in for that event.
Also, is there a way which I can add multiple records versus one at a time?