Getting Values

[glenhest53]

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

[Lee Smith]

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

:(

[glenhest53]

Thanks very much Lee

Dave