AnsweredAssumed Answered

One DB related to multiple DBs

Question asked by mgores on Mar 4, 2011
Latest reply on Mar 4, 2011 by mgores

Title

One DB related to multiple DBs

Post

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?

Outcomes