Yeah, you're on the right track. Except, I think that the Product ID in the Parts table should be in the Job Order table. It should reduce the redundency of the data in the parts table.
__________________
Looking out the window, that's an act of war. Staring at my shoes, that's an act of war. Committing an act of war? Oh you better believe that's an act of war
|