comparing two filmaker db

[KirstyB]

at present I have two data enterers who input results from a very long questionnaire into filmaker 5 database. So i should end up with two identical files. What i want to do useing fm7 is to be able to compare these files and get a report of any fields which do not match between the two different data enterers. So I can check for data which has been incorectly input...any ideas how I can do this?

[Kurt Knippel]

What level of fidelity do you want to check to? For example do you just want to know if there was a difference? Or do you want to know in what field? Or do you want to know which word does not match?

The simplest method is to have 2 calculated fields that basically concatenate all the data together (i.e. Field1 & " " & Field 2 & " " & Field 3 & " " & Field 4, etc) and then another boolean calculation to see if they match (i.e. Concat1 = Concate2).

The same concept can be applied to field by field or word by word...they are just alot more complicated.