Field Validation Sequence
I have three fields Style, Color, and Size which have the following validation rule: always validate, unique, and member of value list. If I leave all of them as blanks (no data) and try to commit the record, the validation prompt kicks in with the custom message I have set. However, I am prompted by the custom message for the second field (Color), not the first field (Style). Is there anything I can do to correct this? The tab order is working as it should. And how can I set these field such that there should be a valid value on the first field before I can enter data to the second field and so on?