I am trying to do a new validation rule on an object - Relationship.
I need to test if another active record exists for the same person record - ie. I want to stop the user create a new relationship for a person if they already have a relationship!
So - basically need a 2 filed lookup on the object Relationship - Active bit = True and Person = Current person on record user is trying to save

Can this be done???