Easy function?Not for me anyway

[AndiM]

Hello, here screams a novice in FM for help.

My problem is simple( not for me)

In database I have two fields, and when I enter one value (number) to the first, the second should show one particulal value(number)The second value is not by some calculation (*, + etc.)but with both fields, I have earlier decided what the second would show when enterin some value to the first.Confused? So, for example

if I enter "30" in the firs field, I want the other to show "50", IF i enter in the first field "40" I want the second show "60", etc.

I figure it is Logigal Function "case" I should used? Is it?

[Ender]

Sure, use a Case(). Or if there's a mathematical relationship between the source and the result, just calculate it (i.e. calc = field + 20, or whatever).

[AndiM]

Could you give me an example of putting values in to case. I tried but did not get it work.

Let`s say I have values as following. field 1,value 20, field 2, matching value 35, then field 1, value 40, field 2 matching value 60.

There is no mathematical correllation between field 1 and 2 values, how do I present those values in "case"?

[AndiM]

Now I got it, just tried and tried.Thanks anyway