...
Is there any other way which completely works like foreign key ?
Set of properly implemented triggers will do.
If you really want to go for complete extravaganza...
:w00t:
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]