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

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