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?
UCC Information entity has FK but it doesn't show up in mapping column (only uccinformationId is visible, instead of loanapplicationid)
I tried mapping using the Loan and UCC Information entities, but neither showed correctly in one to one mapping configuration.
UCC Information - Record Relationship Snippet