I have a database with product names and serial numbers.

I need a script that will keep the user from erasing the 2 fields above.

So if the user changes the serial number and closes the application or moves to another record FM will ask "do you want to save the changes made to product serial number"

And a Yes/No option

Any great ideas?:?

Thanks!!

You can put a validation on those two fields that check that they are not empty.

What do you mean by that?: remember I am a beginner, more or less!!!

Don't I have to create a script so if the serial number field changes by 1 digit or letter the system will aks me if I want to save the changes???

Sorry I may have misread your question. What I had suggested was going to define fields and then click the validation tab. You can make is so that those fields are never empty.

However, upon reading your post a second time, it seems as though you want to check it if it ever changes. I am not sure if you can do it for only two fields. You can though make is so that you ask the user if they want to commit the record or not by unchecking the options to save the record automatically under the layout setup options... But this is for the whole record itself not just two fields.

Any more ideas.....HELP!!!

Try this.

View_Edit.zip

That script is just beautiful. Great.

Thank you.