Hi guys!

Yes, I'm a freak still using FM 5.5v1... I hope there's someone out there who can help with this:

1.- I have a number field called "Number".

In Options -> Validation -> I want to set-up the validation by a calculation as follows:

Only accept if the number is from 20 to 30 or from 50 to 60 (only those two specific ranges).

2.- I have another number field called "Number 2".

In Options -> Validation -> I want to set-up the validation by a calculation as follows:

Only accept if the number is from 1 to 19 or from 31 to 49 or from 61 to 99 (only those three specific ranges).

What's the calculation I should write on each?

Best!

1. (number >= 20 and number <= 30) or (number >= 50 and number <= 60)

2. (number 2 >= 1 and number 2 <= 19) or (number 2 >= 31 and number 2 <= 49) or (number 2 >= 61 and number 2 <= 99)

What Daniele said - only without the parentheses.

Yes, the parentheses are not strictly necessary, but can be used to better understand the calculation. Another way to write 1. :

number >= 20 and number <= 30

or

number >= 50 and number <= 60

BTW: from 7, that calculation could even be written:

or ( number ≥ 20 and number ≤ 30 ; number ≥ 50 and number ≤ 60 )

Automatic message

This topic has been moved from "FileMaker Product Family → FileMaker Legacy → FileMaker.fp5" to "Database Schema & Business Logic → Calculation Engine (Define Fields)".

General topic areas are reserved for questions regarding the tools that were unique with that release of FileMaker. How to questions should be located in the topics that are related to the question.

Hi Daniele and comment,

With and without parenthesis it doesn't work:

If I enter this:

(number >= 20 and number <= 30) or (number >= 50 and number <= 60)

Or this:

number >= 20 and number <= 30) or (number >= 50 and number <= 60

Or this:

number >= 20 and number <= 30

or

number >= 50 and number <= 60

I get the same error:

"This field cannot be used here because it would cause a circular definition"

Any ideas?

Best!

Wait a sec... Let me check something...

My mistake, all 3 work just fine Thank you very much!