Hi all,
This is my uses case. I have a reference table with 2 columns (id(PK) and description) with all the possible statuses: 1 - Ongoing; 2 - Completed, .....
I need to insert an entity case, that it has a FK to that statuses. For instance, idCase = 1, idStatus = 1.
So my question is, what is the best approach to map the value (Ongoing, Completed, ...) into my case CDT?
My initial approach is to have a CONSTANT with the status values: "Ongoing", "Completed" and get the id by a query rule to the table status.
Thanks in advance.
Discussion posts and replies are publicly visible
Best option is to use the record relationship.