How to query one database using data from another one ??

[hvs69]

Here is what I am trying to do.

I have two databases say DB1 & DB2. I would like to do a search/query field A of DB1 using the value in field B of DB2. Here is what I did. In the category>customsearch event I enter the following

category name: DB1
field: field A
value: Here is my problem, I have tried %DB2>field B% and some other combinations.

If I enter the absolute value, it works. But how do I pass the parameter from the database ? I am hoping it is syntax issue.

Thanks.

[hvs69]

Since no reply, I am assuming it cannot be done.