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 Create a Relationship Between Tables.