AnsweredAssumed Answered

Referencing external files

Question asked by BryanN on Jul 23, 2012
Latest reply on Jul 23, 2012 by philmodjunk

Title

Referencing external files

Post

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?

Screen_Shot_2012-07-23_at_12.05.40_PM.png

Outcomes