One DB related to multiple DBs
I have a quotation DB that allows everyone in the company to generate quotes. Our company has 4 different departments that each have thier own DB for keeping track of jobs once they come in. I am trying to come up with an efficient/elegant way to relate the quotes to each of the tracking DBs.
What I am looking to do is - be able to show information from the tracking DBs in the quote file so that we can see which quotes turn into a job (or jobs), start/completion dates, etc.
I currently have relationships set up for each of the 4 tracking DBs to the QuoteDB based on quoteID. The four separate layouts for each dept that have a portal based on that dept's relationship to show records from the tracking DB. Is there a way to do it with a single portal that looks at all four tracking DBs and finds the related records?