Numbers relatioship

[George TOUBALIS]

Well this the problem

I Have a color calculation programme

It use 2 groups of Numbers

1st Group 0-255 (Field B the Result LOCKED )

2nd Group 0-400 (Field A Enter value 0-400)

It gives me one open field to ender a number betwwen 0-400 ( 1, 5, 80, 235 etc)

And One Locked Field

When I write "5" the Locked Field show me "251.75"

Some RESULTS are:

255 < - 0

251.75 < - 5

248.50 < - 10

245.50 < - 15

223.25 < - 50

127.50 < - 200

0 < - 400

What is the relation between two fields?

Can I white a calculation in my FM database To Enter a value (0-400) and have the result In another field.:?

GEORGE TOUBALIS

[comment]

Hi George,

As far as I can tell from your data, this is quite simple.

Define two fields:

Input (number)

cOutput (calculation, result is number) =

0.25 * Round ( 4 * ( 400 - Input ) * 255/400 ; 0 )

Go to Layout mode, and format cOutput as decimal, with fixed 2 decimal digits.

[George TOUBALIS]

it works

Thanx a lot !