Thanks Ed

I have been using surrogate keys for a while now and as you say my earlier problems have stopped happening, however my point was why did they bother to do it this way in the first place.