Comparing all fields

[cblack]

Hi all, I need a way to compare all the fields(about 100) in database A to the fields in database B. Both databases are the same except in content and related by a common field so it should be something like:

if field1 == databaseb::field1

do this

if field2 == databaseb::field2

do this

and so on. Due to the number of fields I would really like to be able to do this via a loop. the only other catch is that i have to be able to append the name of the field to the end of a flag field if it doesn't match. I am new at this and this is really stumping me. I am hoping there is an easy command I just don't know that I can use such as Status( currentfieldvalue ). Any help would be greatly appreciated.

Thanks in advance,

Chris

[mfrost]

Hi Chris!

Wouldn't it be easier to import all the data into one database?

Then you could create a selfrelationship on a certain field.

Then in another formula field you can check how often a certain record appears. Then you can start with your condition.

Good luck.

Matthias