I can't do selects because not all the foreign keys are straightforward. An example, to look up a repair description I use the six digit repair code and go to the repair master file (25,000 rows). However if the description code ends in '99', which means the part is defective and couldn't be repaired, I have to substitute an '01' in place of the '99' before I get the repair description. If I didn't have little quirks like this in the data rules I could build views.

There are a lot of conditions like this in the foreign keys. This is a very old manufacturing system that is running on an AS400 and mirrored to an SQLserver, then I am building a reporting system for management from the mirrored data.