Dear FileMaker Gurus:

There is a FileMaker v.6 DB on Server v.5.5.

Each Book, for sale, has 3 statuses: Active, Freebie and "Out Of Print."

I want to write a script for the "Status" field: if the status is "active," then the price must be "larger than" "$0.00."

Help please!

Happy New Year! Everyone!

Max NY

Well you could script a find so that you set the two fields to the criteria that you want.

Enter Find Mode []

Set Field ["Status", "active"]

Set Field ["Price", "> 0"]

Perform Find [Replace Found Set]

Dear John:

Thanks for you reply!

What I am looking for, actually is:

If the "Status" of a book is listed as "Active," no one is allowed to enter "$0.00" into Price Field. The price figure must be greater than "$0.00."

regards,

Max NY

On then in your Price field definition, validate by calculation.

Case ( Status="Active"; Price > 0 )

Thanks for reply!

Should the ";" in the validation, be "," instead?!

regards,

Max NY

Yes indeed. I forgot that the problem was on FM6. I just read your profile and assumed that it was on 7. So use the comma instead.

Thaaaaanks! Vodka!