Create, Delete And Revert Records

From Dwayne Wright -

Using the commands under the Records menu, you can create and delete FileMaker records with ease. Menu commands such as New Records, Duplicate Record, Delete Record And Sort Records require little explanation. There is a Delete Found Records option as well. This will delete all the records in a table but the term doesn’t say that does it? By found records, it means this command is usually performed after a successful find operation. Say you just found a set of empty records in your table and you want to delete them all in one swoop.

You may have noticed the Undo command from under the Edit menu. This will not work with the deleting of records. There are products on the market that can allow you to roll records back into a table after it has been deleted. The one that I’m using currently is called fmDataGuard.

Here is a link for more information...

At the very bottom of the menu, you can see the revert record command. This can undo all the unsaved changes to the record in that session. A record is saved by default when you exit the record or click outside of one of the data entry fields. A very common term for saving a record is to commit.

If you want to have the ability to roll back multiple fields or pick and choose what data you want to roll back, I’d suggest checking out fmDataGuard for that as well.
More info about the author and FileMaker in general, contact me at

© 2007 - Dwayne Wright -

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.