andrew gothard (2/12/2014)
Basically, if you see a fk which references two tables at the same time ... how does that work? It doesn't, if it's in one table it can't be in the other, so all your inserts to the child table fail.
Yes I agree there. I think they were looking at applying a constraint rather than a FK but my opinion is that you'd want a single FK in a relational database rather than some custom key constraint.
andrew gothard (2/12/2014)If anyone replies to this with "Well you could triggers .. ", please just shoot them and do us all a favour. They're just trying to do something stupid to allow themselves to do something stupid.
Yes agreed there too.
It hasn't been done yet so let's see how it pans out.