I'm actually a .NET developer with little SQL experience. I noticed this circular reference in a new project I am working on and it raised alarms in my head. I have very vague memories of this sort of thing being bad from my school days...

I'd classify it as bad in this case as the people who created and maintained this system have left.

Thanks for all the help.