field validation based on another field
When entering a value into field B, I want to be notified if field A is empty.
This must be very simple, but I am stumpted as to how to accomplish this.
Thank you for any help...
You can create a calculation field which will be invisible on the layout unless field A is empty when it will return an error message "Field A Empty"
If ( IsEmpty ( Field B ); ""; If ( IsEmpty ( Field A ); "Field A Empty"; ""))
Formatting the field conditionally will make the field invisible unless field A is empty.
Thank you, Kazanman!!
Retrieving data ...