Visual Database Tools
The existing relationship must have at least one pair of related columns.
There must be matching columns on both sides of a foreign key relationship. Deleting a column that is part of a relationship will disable the relationship.
For more information, see Creating a Relationship.