I am working on a production report. I need to know if a assembly has been fully issued to based on the issued state of each part.
I think the info will help to explain.
If we look at assemblyseq 0 it is easy to see it is not issued to because all the issued data is no and on assemblyseq 1 they are all yes, but assemblyseq 2 has 2 yes and 1 no. Results I am looking for would be like this,
If they are not all yes I want it to return a no, would be nice as it check the query or table which ever is easiest that it would create or import the results into a new table.