Comparing a field value from Table1 to more than 1 value Table2

[mgavidia]

Hello there!

I would like to know if there is an easier way to do this....

I take the field CallerNumber from the MonthlySourceData and compare it against 4 fields in the Customers  table. If a match is found in any of the 4 fields, the value from InqLeaseNo in Customers table  should be copied to the MonthlySourceData table.

I have managed to get the matching details by Applying Mapping tables on MonthlySourceData (ended up with 4 additional fields in MonthlySourceData); however, getting the InqLeaseNo seems to be a challenge...

Keep in mind that the only connection between these 2 tables is the CallerNumber that could be found on any of the 4 customers fields.

Any tips on working this out will be greatly appreciated.

Thanks,

Miguel Gavidia

[#2]

Hi,

Have a look at the attached document and hope it helps!

Kiru

[mgavidia]

Hi,

I got my script to work but I jumped thru several steps..

Your process looks like will do the trick with a lot less steps; I'll give it a try and report the results...

Thank you very much!

Miguel Gavidia

[#4 · Accepted solution]

Sure, No problem!

[mgavidia]

Kiru,

I applied your process to my script and it worked flawlessly!

Thanks again for your help.

Miguel Gavidia

[#6]

No problem, I am glad you got the  desired result!