please help again, i need a script to do this:

i have a field (field1) with number values.

what i want to do is to find the value on that field (field1) which is equal or the first greater than value to the value on field2. and put tha3 value on field3 which is the opposite on a new field via a script.

for example:

field1 - fiedl3

3 - 4000

4 - 5000

56 - 5600

78 - 6400

90 - 6800

102 - 7000

120 - 7200

on field2 for example the value is 101

so we know that 102 is the first greater than value to 101. so field 3 should contain the value 7000.

i hope i explain myself.

Edited June 11, 200718 yr by Guest

Hi sirtemplar,

You need to read about creating Serial Numbers.

Start with the Online Help (available when FileMaker is open)

Lee