AnsweredAssumed Answered

One DB related to multiple DBs

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


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?