Linking fields to value list selections
I have a problem someone can hopefully help me with. I want to define a radio button value list, that when selected will populate a separate field with a set value. Each radio button choice will have a different value.
I want to set the radio buttons as
The values linked to these would be
P1 = 500
P2 = 1000
C1 = 1000
C2 = 2000
So on my database, when I select P1, another field called MR gets populated with 500, select C2 and 2000 appears.
Any help would be appreciated,