Pipedrive had this and we used it for things like Primary Contact on Company records and Referred By on Deals.