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?