dscss8996
2014-10-20 13:04 阅读 101
已采纳

Salesforce:映射字段

I need suggestion regarding how can I map below fields which we are using as affiliates.

1) Affiliates/Account
2) Account Users
3) Account Manager
4) Offer
5) Advertiser

Below is current relationship between them --

i) Affiliates : Users - 1:M
ii) Affiliates : Account Manager - 1:1
iii) Affiliate : Offer - 1:M
iv) Advertiser : Affiliates - 1:M
v) Offer : Advertiser - 1:1

For now, we are mapping with SF as,

1) Affiliates >> ACCOUNTS
2) Account Users >> CONTACTS

Please advice on mapping.

Regards.

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    dsaf415212 dsaf415212 2014-10-28 14:33
    i) Affiliates (one to many) Users:
    

    Create a lookup relationship on the User object pointing to Affiliates object

    ii)  Affiliates (one to one) Account Manager:
    

    Create a lookup relationship on Affiliates pointing to Account Manager, add a trigger at account Manager to prevent having more than 1 affiliate.

    iii) Affiliate (one to many) Offer:
    

    Create a lookup relationship on the Offer object pointing to Affiliate

    iv) Advertiser (one to many) Affiliates:
    

    Create a lookup relationship on the Advertiser object pointing to Affiliates

    v) Offer (one to one) Advertiser
    

    Create a lookup relationship on Offer pointing to Advertiser, add a trigger at Advertiser to prevent having more than 1 affiliate.

    点赞 评论 复制链接分享

相关推荐