Referencing external files
So I have one db that includes customers, vendors, jobs, purchases, quotes, inventory, etc... All working great with correct form.
I'm developing a concurrent database that will house our test reports for these jobs, customers, etc.
When in the relationship graph, I have 1 table that is local to the Test Reports database and I've imported 1 table (jobs) from the Customers database.
My question is this:
In order to make the chain of relatioships go Customers -> Jobs -> Test Report X, do I need to import both the Customer's and Job's table occurances into the relationships view or does just the jobs occurance being imported from the external table keep that relationship anyways without bringing in the Customers table occurance?