Michael,

Perfect....I really appreciate the reply. I was glad to read your answer, because I had already started re-doing all my tables with unique indices and revised (composite) FKs. I also re-added the CompaniesID to the EarningsMiscWrk table. It seems to work great...!

I'm hoping that a unique index is an ok form of the constraint (as it was really easy to add visually with Management Studio)...

Thanks again for all your help...