Question Problem: I need a choice of data to effect another set of data.

[Tommy888]

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)

 

[Steve R.]

First, it would appear that your table structure needs work. You wrote:

the points allocated for each of these posistions can be different depending on the type of race the drivers are taking part in.

Based on what you wrote, it appears that the "race" table needs to have a fields to hold the reference points and race type. Read up on normalization. Then, if I understand what you want to do, following the race, the reference points would then be modified based on the driver's finishing position and transferred to a race results table.

Second, use the "Select Case Statement" to handle the situation were the driver comes in 1st, 2nd, 3rd, so on.