Validate using IsEmpty or Less than/Greater than

[crazylegs]

I am using FileMaker 5.5 on a Mac

If the field "Total Material" is empty or less than 1 (this is a calculation number field)

I should to be able to enter a number in field "Other Total" (this is a number field)

If the field "Total Material" is NOT empty or is greater than 1 (this is a calculation number field)

I should NOT be able to enter a number in field "Other Total" (this is a number field)

[LiveOak]

Should I guess at a question?

Attach a script to the Other Total field:

If(IsEmpty(Total Material) or Total Material < 1)

Go to Field (Other Total)

else

Go to Field ()

Make sure you take Other Material out of the tab order.

As an alternative, you could use this calculation as a validation calculation for "Other Total".

-bd