Skip to Content
0
Former Member
Oct 31, 2016 at 02:51 PM

How does Referencing Data Source Key Field work in cloud data source in c4c?

450 Views Last edit Sep 04, 2017 at 01:10 PM 2 rev

Hi Experts,

I am relatively new to cloud data source in c4c.

I came across columns Referencing Data Source and Referencing Data Source Key Field in cloud data source.

From Admin guide,I got to know it works similar to Foreign key constraint in SQL.

I created a Test CDS to know how it works with the following fields.

1.ZID - with Referencing Data Source - Account Master and Referencing Data Source Key Field - Account ID

2.ZName

And I tried to upload a file with Account ID having the value -1.To my surprise it got successfully uploaded,even though there is no Account in Account master with Account ID -1.This is not how a foreign key constraint works.

Can anyone please tell me how does Referencing Data Source Key Field work in cloud data source in c4c.

Please find the following screenshots.

sample-cds.png

cds-data.png

Attachments

sample-cds.png (34.9 kB)
cds-data.png (22.2 kB)