AnsweredAssumed Answered

Relating Two Files/Databases

Question asked by LeahRiley on Apr 9, 2013
Latest reply on Apr 10, 2013 by philmodjunk


Relating Two Files/Databases


     I have two distinct databases.  One is about customers (who they are, what product they received, when, etc).  The second is about our products/data (Our expected performance, the physical properties, etc).

     These two databases can be linked by the Product Name.  

     Both databases are complex with many connections/tables.  For example, the products/data database has product name, linked to format tested linked to performance data.  

     PROBLEM: I want to be able to be in my Customers database and be able to pull up performance data from my second database.  However, I don't want to load up every single table and relate all of them.  

     QUESTION: Is there a way to use my existing links to get my information?