Jump to content

Omitting duplicate records


tottijohn
 Share

This topic is 5779 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5779 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.