Hi Team,
I have two CDTs with a one-to-one relationship, which I have already designed and stored. Now, I plan to create records from the database tables. However, I encountered an issue when trying to define the relationship in the records due to the existing CDT data model design.
In my current setup, the child table's primary key is used as a foreign key in the parent table. My requirement is to fetch the parent table data along with the corresponding child table data. However, with this setup, I am unable to establish the one-to-one relationship in the records as intended, and I prefer not to make any changes to the existing CDTs.
Could you suggest a solution or provide guidance on how to achieve the desired relationship in Appian records without altering the CDT design?
Parent :TP_EmployeeDetails
TP_EmployeeAddress
Discussion posts and replies are publicly visible
For a one-to-one to work, both fields must be unique. I do not see a way to do this without at least changing this in the backend database.
Sometimes I just ignore this and make it a one-to-many.