CDT Mapping Primary Key and Foreign Key

I have a main table say ABC which has ID column as primary and identity. I have another table DEF where I have another column say CASE_ID which is both primary and foreign key but not the identity. In the second table DEF I have provide the reference as ABC.ID.

I have mapped the second table CDT DEF in CDT ABC, however while verifying the Data Store, I am getting the error "The data source schema does not match the type mappings: Missing column: CASE_ID in dbo.ABC (APNX-2-4056-000)"

My Requirement is to map the second table as @OneToOne Relationship with first table. Please find some screenshots for reference in attachment.

Please provide any solution for this. Thanks

OriginalPostID-261496



  Discussion posts and replies are publicly visible

Parents Reply Children
No Data