AnsweredAssumed Answered

Compare records accross tables

Question asked by revmk on Jan 27, 2014
Latest reply on Jan 27, 2014 by mikebeargie

Hello all,

 

I've run into developers block and need some suggestions.

 

Simply put I am trying to compare records in table A with records in table B. This search needs to be a little fuzzy in logic (so I can't use a relationship).

 

As table B has an unusual format (which I can not change) I have placed the useful fields from it into a list. So I now have a list of 'keywords' in each row I wish to test each record in table A for the presence of.

 

The only problem is I can't now think how I can do this. The find *"" does not seem to support either lists or variables.

 

Any suggestions?

 

Thanks

Outcomes