Thanks for the snipping tool information, I'll start using that.
Well, I recently added the WO Master table because I thought that would take care of the issue, which it didn't so I went back to how I originally had it, which is without the "WO Master" table.
The WO HDR has distinct doc_no so I have everything back to how you suggested I create the measures. My total work orders is off the exact same amount of the work orders that don't appear in the WO_LINE table.
We create a work order, which appears in the WO HDR table(Doc_no). If the work order gets parts assigned to it, it will appear in the "WO_LINE" table. I have a few work orders that don't take parts, so no entry is found in the WO_LINE table. My numbers are off by the amount of work orders that didnt take parts.
A customer sends us part "A" to work. When we enter it into our system, it gets assigned a unique number called "Doc_No" and gets one line created in the WO_HDR table. That line has a column titled "Part Number", which is "A", the part we are working.
Now, we tear apart part "A", and find all internal parts that need replaced, lets say three parts need replaced. We then add those three parts to the work order, which gets recorded in the WO_LINE table. Each line in the WO_LINE table has a column called "Part Number", which is the part number of the part we issue to it.
So, WO_HDR partnumber column is unit being worked, the WO_LINE partnumber is the parts used to complete the unit being worked.
In the above example, one line is in WO_HDR table, which has a part number of "A", and three lines appear in the WO_LINE table, which each line has its unique "Part Number", the parts that take to fix part "A".
The two tables are linked by the Doc_no
Sometimes, no parts are found to be bad, so no parts are issued to it, so nothing gets recorded to the "WO_LINE" table. Those doc_no are not being counted.
I just linked the part number to the wo_line and I think that with other searching and fixes worked. I believe I am getting accurate information now. Thank you for your help on this. This forum is invaluable and so was your help!