You need to sign in to do that
Don't have an account?
manjiri
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
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