Lookup that will look in 3 different related databases
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?