>As long as the keys are unique is that not all that matters for relational integrity? Why does it matter where they come from?
Outside audit firms like it when your keys are easy to follow. It makes it easy for them when they see missing rows because the chain is broken and then continues.
I work in the banking ACH industry, so making it esier for them makes it much easier for me. :)