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.