Leaving records incomplete by mistake

[Maxwell Morlay]

Is there a script or calculation that sends an alert to a data-entry person who forgets to enter information in certain fields?

What I have in mind: When exiting the record (for any reason), the person leaves the address or zip field(s) blank, I want a beep/message that says "YOU ARE LEAVING THE RECORD WITH INCOMPLETE FIELDS. PLEASE COMPLETE THE DATA ENTRY"

Thanks.

[LiveOak]

There are a couple of approaches:

1) The quick and annoying way is to use FM's built-in field validation and set it to "not empty" and setup a custom message.

2) The best way is to build the validation into your navigation from layout to layout. This requires that you disable the user's ability to manually change layouts, lock the status bar, etc. This sort of control is best thought about when you first begin the design of a database system, it's significantly harder to "add on".

-bd

[mdpres]

The best thing I have found is oAzium "Events" from Waves in Motion

you can trigger all kinds of scripts without locking layouts or with buttons etc. Their web site is wmotion.com.

Dean