Thank you for your post.
An easy way to do this is to create a calculation field (MR) with the following formula:
Case (RadioButtonField = "P1"; 500;
RadioButtonField = "P2" or RadioButtonField = "C1"; 1000;
RadioButtonField = "C2"; 2000;
That is, it evaluates the the different values of the RadioButtonField and puts in the corresponding value.
Wow, thanks for such a prompt reply! I was off with lookup tables et al, this sounds a lot more compact!
Appreciate your help.