Yea our tables don't have any relational information set up, they are coming from and AS400 into SQL server and no one really knows how they tie so we are...

Ok I really appreciate the suggestions. Do you know if by using the database diagram you can set it up so that you can make sure you don't change any...