Script to find changed fields & create new record

[MikeKD]

I'm trying to overcome limitations of FM Mobile using some scripting - here goes what I want to do:

1. Run a script automatically after sync (I /think/ this is easy!)

2. Which will - find any records in a couple of fields that have been modified since last sync. (no idea how to do this!)

3. Create a new record in a different table. (not sure how to do this, must have some information from current record).

4. reset the original fields to null so I can do the same again. (easy?)

5. tell me that some records have been created when I next open the database. (haven't tried yet!)

Any ideas?