Creating a timestamp attached to a specific record in FileMaker Pro 5.5
I have created a database that numerous departments will have access to and need to respond to. In order for our QA system to work we need a means of tracking revisions/versions of the record. I would like to do this automatically by time & date stamping a certain field. Thus when Field A is modified, the date and time stamp would appear. I would need to do this for 6 fields, all having different time and date stamps. How can this be accomplished?
You'll need to define all 6 fields as separate records in a file of related records. Since you want both date and time recorded and 5.5 doesn't have timestamp fields, you'll need to define separate date and time fields with field options that auto-enter the modification date and modification time in their respective fields.