> After reading the responses, and re-reading Appendix 2 in your book, it looks like I really should have an intermediate table instead, that links OrderedParts and the Invoice table, and remove the fk_invoice from OrderedParts. Would this be a correct assumption?
Paul,
That sounds like the best approach to this particular problem.