I have a one-to-one relationship between the Loan and UCC Information entities, and I'm trying to add the same relationship from the Loan record, but it doesn't recognize the FK (Only displays entity's PK) from the 'UCC Information' entity for some reason.
Any kind of pointer will be valuable!
Loan Record Relationship Snippet
ER Snippet
Discussion posts and replies are publicly visible
Have you a formal foreign key set up in the CLN_UCC_INFORMATION_T table?
adding unique constraint fixed mapping issue.
Great!
I Added unique index on the column and update CDT with @uniqueconstraint in CDT but still foreign key is not showing up in one - one relation. do you have any suggestion to fix?
You need to re-map the field in your record type to have the record type realize that this is now a unique constraint. If you go to the record type you should see a banner at the top that tells you there are unmapped record fields. If you then select the button on the banner and re-map that field, it should mark it as unique and you can select it correctly as a related field.