Jump to content

How to compare 2 files to find most current change


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

Recommended Posts

  • Newbies

How can I compare the data in one FM data base file to the data in another FM data base both having the same fields? I have someone in another city that inputs sales lead information. The original data base is updated before the new leads are merged into the original file. There are date and time fields for each record when they are created and changed. I need to compare the data in several fields so that the most current data is kept. How can I do this?

Platform: WIN 2000 / Version: 5.00.2195 Service Pack 4

FileMaker Version: 6.0V1

Platform: / Version:

FileMaker Version:

Platform: / Version:

FileMaker Version:

Link to comment
Share on other sites

With great difficulty, as the old joke goes.

Do a search in the Forums for "synchronization" or "synchronisation" or other similar words to see the techniques (or frustrations) that other people have found.

You could try using the Status(CurrentRecordModificationCount) function to compare how many times the record has been modified. The Exact () function is good for comparing strings, it even picks up capitalisation differences.

Platform: / Version:

FileMaker Version:

Link to comment
Share on other sites

This topic is 6554 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.