> 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.