Jump to content

Comparing all fields


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

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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 smile.gif" border="0

Link to comment
Share on other sites

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