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?
If first field can never be empty, then you could try an OnObjectExit trigger that could use a calculation for validation, and an Exit Script: False. Just remember that the user will have to enter a Style or never get out of the record.