making fields mandatory, but with a stipulation

[dcecil]

I am trying to make a field mandatory, but only if any one of six other fields have been modified. That is, if any of the six fields have been modified, you cannot go to another record, without having first filled in the mandatory field. I hope this explains it well enough.

Thanks,

Dave C.

[LiveOak]

This first thing needed is to control navigation from record to record by locking out the status area and menus. Next you need a way of determining if a field has been changed. One way is to display each record with a set of global fields, one for each actual field. When you navigate to a record, a script copies each regular field to the corresponding global. When you click the next record button, a script checks each global against the regular field to determine if changes have been made and then either moves to the next record or shows a message with the errors to be corrected.

-bd