July 13, 200421 yr Hi I've created a value list "Photo Size" containing values such as 2 x 35 2 x 45 2 x 55 How do I relate the value selected to a numerical field For instance if someone selects 2 x 45 from the value list I would like 100 to appear in the numerical field. cheers Dave
July 13, 200421 yr Hi Dave, You can do this using a case calculation. Case(Photo Size = "2 x 35", 100, Photo Size = "2 x 45", 200, Photo Size = "2 x 55", 300) HTH Lee :(
Create an account or sign in to comment