I'm not to sure how to go about this but I have a few users that play with some buttons including the new records button, thus creating lots of empty records. This might be very easy but I can seem to figure it out. What I need is to preform a check.....Are you sure you want to create a new record? Yes or cancel. to give the user a chance to cancel before the record is created.

Any help?

RET

In my experience, overuse of "Are you sure?" confirmation screens tends to get annoying after a few hundred times... make that one time. And if you make something annoying, your users will find a way around it.

One route that many FileMakers employ is to create a "New Record" screen that has only global fields on it. The user can start entering data, or cancel. No new record is actually created until the Done button is clicked, which transfers the global data to the appropriate fields of a new record.

On the other hand, some sort of annoying thing might be just the ticket to stop people from acting like little children.

Another solution is to require a valid entry in one or more fields. That way, anyone creating a new record won't be able to escape it until those fields are filled in.

Alternatively, you could create a "close" script that runs automatically when the file closes, finding blank records and deleting them.

The sad fact is that if explaining to people that they shouldn't just create new records for the fun of it doesn't work, you probably have to annoy them.