Hi,
Ok so I struggled to describe the problem in the thread title so I'll explain it in more detail here. I am making an access database for kart race scenario. The drivers can register for races and track their results for a particular race or agregate races. A driver can have points allocated for first, second, 3rd and 4th place and so forth. My problem occurs because I the points allocated for each of these posistions can be different depending on the type of race the drivers are taking part in.
Therefore I need a system that can record their results for each race and decide points based on their posistion and the race type. Any ideas how I would go about having different points for different race types.
If you need me to explain furthur please ask. At the moment this is how my system works on a basic level.

Click for bigger image, (imgshack)
Ok so I struggled to describe the problem in the thread title so I'll explain it in more detail here. I am making an access database for kart race scenario. The drivers can register for races and track their results for a particular race or agregate races. A driver can have points allocated for first, second, 3rd and 4th place and so forth. My problem occurs because I the points allocated for each of these posistions can be different depending on the type of race the drivers are taking part in.
Therefore I need a system that can record their results for each race and decide points based on their posistion and the race type. Any ideas how I would go about having different points for different race types.
If you need me to explain furthur please ask. At the moment this is how my system works on a basic level.

Click for bigger image, (imgshack)