Let me give an example. There are 3 fields Fd1, Fd2 and Fd3. Only 3 sets of valid values are allowed to be entered into the fields:

Fd1 Fd2 Fd3
--- --- ---
0 0 0
1 2 3
4 5 6

Suppose, the user entered 1, 2, 6 into the fields. But the correct values for the current record should be 4, 5, 6. A good user interface will allow the user to go back to Fd1 and Fd2 to change their values to 4 and 5. Any other arrangement cannot be considered as user friendly.


>Should it matter wether the Row or Column has changed, you must still validate the data.
>
>Regards
>Mark