Update value of one field dependent on the value of another.
Am just wondering if this sort of thing is possible....
I have a table which includes two fields:
Rank
Score
Rank can be 1, 2, 3, 4 or 5.
Score needs to be 10 (for a Rank of 1), 6 (for a Rank of 2), 3 (for a Rank of 3), 2(for a Rank of 4) or 1 (for a Rank of 5).
So basically if the Rank field is updated to 1, can it be set up so that the Score field updates to 10 etc?
Thanks.