Multiple database search - another

[bdarch]

There is a post

Here

to which I have an almost-identical question but focusing on different results - in my case the multiple databases are different but related by links to (in our case) Projects.

People, correspondence, inspections, project data, and so forth are all related by project number. The information is different enough that separate tables (files... we built this system under version 5.5 and have brought it forward into 9).

I was asked today if a search was possible across multiple databases - returning the hits regardless of where they were found (for example, identifying all the reports, inspections, and correspondence for a particular project).

What would be the best way to approach this?

Thanks!

[Søren Dyhr]

The information is different enough that separate tables

Nice one! When will it become that, pretty subjectively chosen would I say - Or have you pulled the lot thru all the normal forms.

This gives you away:

for example, identifying all the reports, inspections, and correspondence for a particular project

...shouldn't they have been related in the first place??

--sd