Quote:
|
Originally Posted by feelgood
Parts {
partId = 1, jobId = 1, productId = 2, qty = 4
partId = 2, jobId = 1, productId = 2, qty = 1
partId = 3, jobId = 1, productId = 2, qty = 8
partId = 4, jobId = 1, productId = 2, qty = 1
}
|
This is telling me that the same product is listed against one job order several times with different qty's. This wouldnt happen would it? More likely this would happen:
Parts {
partId = 1, jobId = 1, productId = 2, qty = 14
partId = 2, jobId = 1, productId = 4, qty = 5
partId = 2, jobId = 2, productId = 3, qty = 1
partId = 2, jobId = 3, productId = 2, qty = 12
}
..etc
What i'm saying is, a quantity of one product would only be listed for one job in this table once.
Surely this is how it would work in practice? Or am i not getting the way the system works.