Trying to tie everything together into one report from database

[zach48191]

June7

I am still not fully understanding relationships. Why is WorkOrder in modules and Assembly? Why is Module_S/N in NMR and NMR_Number is in each Module (a 2-way relationship - makes no sense)?



For each module or assembly that is worked on the technician has to charge it to a work order number. This is a number that the program uses to charge time so the bean counters can determine the budget to the program. So everything has a work order number in the production of the final assembly.


What exactly is an NMR?

An NMR " Non Conformance Material Report" means basically that there is a discrepancy with the part, and needs to be reviewed. This is important for process improvements as it is data for collection. That is why each module might have a NMR and which is why I linked it to each module as it "could" have an NMR associated with it. Basically I would eventually like to run an NMR report and filter to show just modules that have an NMR number with it.

I really need a better understanding of your process.

As I said, manufacturing not easy and I've never built one.

I have attached my revised database with the spaces removed from the fields like you stated.

Example Database.zip

[June7]

Does that mean a module can have a different work order number than the assembly it is part of? Is a module associated with only one assembly? This is a 1 to many relationship - 1 assembly has many modules but a module has only 1 assembly.

I should have some time this weekend to review this in more depth.