It seems to me that if you implement Validation on your second filed, something like (by calculation) If ( IsEmpty(field one);" ") that should work. Then set things up to ake a custom response to the Validation Error.
i'm on an iPad at the moment so cannot test what I just wrote.
That is how I first thought of doing it but can't figure out how to alert the operator that the entry is not valid or allow the entry if it is valid. If I put " " as the first result of the if statement that doesn't alert the operator that they are in the wrong field...and what do I put in the second result of the if statement to allow the entry to go forward?
It was getting late last night and after looking at your answer and trying it again this morning I found that it does work. The problem I have is that when I validate at the field level like this the user gets two messages in addition to the one I created. The two from fm ask if they want to revert the record. The question is asked twice and the users are getting confused. Looks like to keep this clean and not confuse the users I'll have to use script triggers so I can have more control over how the system reacts.
Thanks again for you response,