+ Start a Discussion

Help required for building custom object relationships



I am converting SQL database to custom objects.

In typical SQL database  there are many columns referring to Id in some other table. They have one-to-one   relationships with that table. But in salesforce we can not have one-to-one relationship. So what will be the possible workaround?

Are there any Best practices to use? Is there any guide for designing?

Writing triggers and checking is one way I found, but it is again long way if there are many objects in the system.

So if anybody worked on similar kind of thing please help.






Yeah one-to-one is something you don't have out-of-the-box. Foreign keys and relationships work slightly differently within Salesforce. If you have a parent object A and want to relate it to an object B you can either create a master-detail relationship or lookup relationship. More details can be found with here .