Flagging Modified Records for Update

[Bill Tuttle]

Hi - I have a system that uses FileMaker to manage the items for a shopping cart. They are transfered to an MySql server on the site. I want to timestamp a record when it is modified and when it is updated to the MySQL server.

If I use the regular modification date it is fine until I update the field that tracks when it was last posted. Then the modification date is updated again. I want to be able to select all records that have been modified, but not updated. Any recommendations?

Thanks.

[Paul de Halle]

You could create a 1-to-1 relationship with a new table which is used purley to store the SQL upload timestamp. This will then not affect the modification date of the parent record you are checking on.

[Bill Tuttle]

Thanks Paul - I think that's what we'll do.