Hi Noel,
quote:
Don't see the problem here... If the Manager gets deleted, so would the ID, so there is no difference in it.
there is a huge problem!!!
First thing to do when dealing with managers is to give them some nicely colored PPT slides, you then might be able to keep them out of the production process. Having done that, you are able to get to real work 
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]