I could use some help with this calculation; it is part of a script.

We are on FM6

Case( Revision # = 0,"R1", Revision # > 1,"R2", Revision # > 2, "R3")

I want the revision # to go from an empty field to R1 then to R2 then to R3, etc. Clicking a button triggers the script which also fills in two other fields.

Currently the script goes from empty to R1, then R1 to R2, but will not go to R3.

thanks for the help.

I hope you got my e-mail, Jimbo.
I THINK it has the solution to your problem...
.

no i have not seen an email

Hi Jim,

You'll just want to change the order of the tests in your case statement: FileMaker stops evaluating at the first matching test (>1) and won't go on to test for > 2, etc if the record number is already greater than 1. "Case" is a "first match" not a "best fit" test.

Hope that helps,

John

What is Filemaker's "best fit" test?

LookupNext ()