The end goal here: I am trying to get inspection data entered through MES into information that the Operator can use at point of entry and Quality can analyze for trends.
I can join the InspResultsNum table to the JobOpr Table [via Company, Key1 (Job), Key2 (Assy), and Key3 (oprSeq)]. But I have to pull all 200 Fields from InspResultsNum to identify the eight fields that are actually entered for this job/Part (of course there will be 8 different fields for the next Job/Part).
In addition when the data is pulled; the fields are Number001, Number002, etc. This is not a useful descriptor for knowing what data you are looking at for analysis.
Joining the InspAttr table (InspAttr has the Field Name assigned to the Inspection Attribute) to the InspResultsNum table, so you could at least see the Number001 Field Name associated with an Attribute Description in each row of inspection data, doesn’t add value because you get one-to-many multipliers because there are 50+ attributes in the table.
I am concluding that I will need a unique BAQ for each Inspection Plan, SpecID, Attribute, etc. To display/analyze them effectively. I hope I am missing something really easy here.