+ Start a Discussion
manjirimanjiri 

Help required for building custom object relationships

Hi,

 

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.

 

Thanks

wesnoltewesnolte

Hey

 

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 .

 

Cheers,

Wes