Well, Salesforce offers one to many relationship and recently Many to Many relationship has also been possible using the concept of a Junction object...
But, is there a One to One relationship in Salesforce. Well, it is not available out of the Box. But is definitely achievable using simple workflow rules...
Scenario:
Let's consider the scenario that we would like to establish a One to One relationship between Accounts and Contacts..
Step 1:
Create a custom field on the Contact object. Make the field unique. This field would be used to hold the ID of the associated Account.
Step 2:
Create a Workflow rule on Contact. Update the custom field with the value of the associated Account ID.
Done!! you have established a one to one relationship between Account and Contacts...
When you try to add a second contact to the Account, the "unique" constraint would be violated and an error would be thrown.....
But, is there a One to One relationship in Salesforce. Well, it is not available out of the Box. But is definitely achievable using simple workflow rules...
Scenario:
Let's consider the scenario that we would like to establish a One to One relationship between Accounts and Contacts..
Step 1:
Create a custom field on the Contact object. Make the field unique. This field would be used to hold the ID of the associated Account.
Step 2:
Create a Workflow rule on Contact. Update the custom field with the value of the associated Account ID.
Done!! you have established a one to one relationship between Account and Contacts...
When you try to add a second contact to the Account, the "unique" constraint would be violated and an error would be thrown.....