Searching Over multiple files

[John Pepper]

I have a 2 relational databases.

"Problems", and "Problem Revisions".

They have a one to many relationship based on problem number.

From the "Problem Revisions" database I wish to search for all problem revisions where the status of the problem is open and the revision of the problem has my name on it. The web companion only allows searching on fields in one file. Is there a way I can make it search over two. IE: "Status" in "Problems" and "Person" in "Problem Revisions". Thanks

[John Pepper]

I figured it out. Sorry. Just had to configure which layout to use as a source for the search fields.