Skip to main content
March 15, 2022
Question

Records Add Relationship (One to one)

  • March 15, 2022
  • 7 replies
  • 0 views

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 

7 replies

andrewh0007
March 15, 2022

Have you a formal foreign key set up in the CLN_UCC_INFORMATION_T table?

March 15, 2022

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