the database has had at least five other developers working on it and from what I can tell, each basically re-wrote the database but kept all the legacy stuff from the prior developer!To me, this would be a good candidate for a complete re-design, from scratch.
Sandra