Hello,

I have some fields which set cannot be empty, strict do not allow user override validation. Because they are very important. But, during user enter record, they sometimes need to go to other database and find data. My validation rule make them so inconvinience because somehow they cannot go elsewhere unless they fill out the required field or delete the record. Please help.

Damon

Don't use the built-in validation. Take the use to a new "entry" layout, provide global fields on the layout for data entry. Display of data needed from other files using portals, menus, etc. When the user is finished entering data a "Submit" button is clicked. A script connected to this button provides all the validation and error messages. If all is correct the script creates (or modifies) the desired records and copies the data from the globals to the real fields.

-bd

Thank you very much first! If I use the global field to for data entry, then how to avoid user to press CTRL-N a shortcut to perform new record command.