In a FileMaker3 database, we would like to record the number of times a field in a databade is changed.

What is the most efficient way of keeping track of the number of times a change has been made?

Sample script, perhaps? Our fields are defined and we have a "ChangeCount" numerical field already in place.

Thanks. -- jal

------------------

========================================================

John Lutz - [email protected] 802 296-7015

Vermont Stamp - Home of Pictorial Permits

1523 Maple Street, Hartford, VT 05047-0501

http://www.vtstamp.com fax: 802 296-2715

========================================================

quote:

---

Originally posted by jalutz:

In a FileMaker3 database, we would like to record the number of times a field in a databade is changed.

What is the most efficient way of keeping track of the number of times a change has been made?

---

Start by making sure that you (the developer) controls the number of time a user is able to change the field. I would do this via a scripted navigation system.

Once that is under control, then have an editing layout, where the user is able to edit the field, as well as a browse layout where the user is not able to edit the field.

Now use some kind of scheme to determine if a change has been made. A simple way is to stick the field in a global field (or in duplicate field) and when the user moves off of the editing layout (via a button) compare the field to the place where you stuck the original value. If they differ, increment your counter.

You can also use this to log the changes.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=