Search across multiple dbs

[laker_42]

I am trying to come up with a script that will look to see if a record has been created for an employee in 6 different dbs. If there is a record for the employee in any of the dbs, I need to know where it is. The databases are not related. There isn't any direct relationships. I may have to end up creating them to accomplish this. Is there a way to send a field value to a file that is not related? Here is what I think I need to do in order to accomplish this:

In the main file, create a script that will call sub scripts within each of the 6 files. It somehow needs to pass the field value to each of the files. Then within the files I will run a search script. I then need to return the results of the search to the main file.

Any ideas or has anyone ever done anything similar? I don't know if I explained myself good enough so I will answer any questions that you may have about it.

Thanks!

John

[laker_42]

I believe I have found a solution to this. It may not be perfect but it will work.

[color:"red"] I do have another question. Is there a way to suppress the message box that appears when no records are found after performing a find?

John

[Kurt Knippel]

Set Error Capture [On]

Will supress the error messages.

[laker_42]

Thanks!!!