My database will consists of loads of duplicates to act as a backup whenever there is any amendments needed, but i only want to display the lastest of the duplicates, omitting and not deleting the rest.

Each record is accompanied with a timestamp. I tried using the lastfunction but the results aint good, thus i am trying to script this omitting duplicates without any result.

http://fmforums.com/forum/showtopic.php?tid/179030/post/216003/hl//

Try that to isolate the duplicates (of course don't use delete records).

You may have to use some sort of marking system such as a number field that = 1 if it's the current "Main" record. And then Conduct searches based on that.

The Backups or your records should be kept separate from the active data.

Setup a routine to back your files on a regular bases, be sure that it is often enough to limit the exposure to loss of data. The schedule could range from several times daily to much less frequenly depending on your particulare needs.

If this is considered old data, then the back up will probably all you need to do, however if you need to see this data, then consider changing viewing the data in a portal.

Lee

Genx, i was like,"Woah, why didn't i think of that?!" when you suggested using number field on the main record.

My knowledge is growing everything you post in my thread, thanks Lee!