AnsweredAssumed Answered

Lookup that will look in 3 different related databases

Question asked by jlenberg on Dec 8, 2009
Latest reply on Dec 11, 2009 by comment_1

Title

Lookup that will look in 3 different related databases

Post

I have a database of thousands of phone records that are recorded each month. Monthly, I need to identify which of my clients received the call based on their telephone number (key) that is in the record. The results will populate the clients account number and clients name in the proper fields for the call records.

 

The problem is, I have and must maintain 3 different client databases. Presently, I do a lookup in client_database_1, then, go to the "Define Fields" and change the lookup parameters for the Account Number and Company name fields so the next lookup will be for client_database_2, then I do the same thing for client_database_3.

 

Is there a way to write a script to do lookups for the same fields in multiple databases? 

Outcomes