Finding in Multiple Databases

[john.daly]

Write a script to perform a find in Database A with error capture on. If Status[CurrentError] = 401 (no records found) after performing the find then run an external script in Database B and repeat the process if no records are found in B.

[srtackett]

I have three databases:

A) holds current projects

: holds completed projects

C) The other uses information about the projects.

All projects have unique ID's.

Is there a way that I can make a search request that will (by ID) that will look first in A, and if not found there, will look in B and return the results???

All three are related - I can get the results I need back as long as I only search in one of the databases.

Thanks,

Shane