I need to make sure a number field "fieldA" is NOT empty when another text field "fieldB" has certain text in it.

I also would like a custom message alerting the user when this situation happens and they can't proceed until they add the data to the number field.

Please help!!! :)

Welcome to the Forums!

Open Define Databse (Ctrl + Shift + D)

Choose fieldA, double click it

A window will come up with field options

Choose the validation tab

Click "validate by calculation"

Insert the following calculation which tests your conditions: Case("fieldB" = "specific value" and IsEmpty (fieldA) ; 0 ; 1)

Click ok to save the validation calculation

Then in the validation tab again, choose "display custom message if validation fails"

Insert the message for your user in the now white box.

Finally, if you don't want your user to be able to overide the data validation, still in the validation tab, unselect "allow user to override during data entry".

Good luck

~Genx

Thank you Genx

I must be doing something wrong

I did what you said for some reason it did not validate :

here is the calc I created...

Case("Job created" = "new router" and IsEmpty (qty to be built) ; 0 ; 1)

"Job created" is the text field and "qty to be built" is the number field

Do you see anything I might be missing?

Oops, sorry, my mistake, i only put FieldB in quotes because i was reading it off your example , change it to be FieldB without quotes.. i.e.

Case(Job created = "new router" and IsEmpty (qty to be built) ; 0 ; 1)

That did it!!! Awesome thanks again Genx!! :yourock: