Hi All, I am getting a datatype mismatch erro when I am connecting and creating a fk from a pk from another table.Each and every confirguation is same for both the columns except the following:
Can you please guide me on what mismatch I am missing as this is a usual case and easily implementable.
Discussion posts and replies are publicly visible
Did you try to find an answer outside of Appian as this is not an Appian issue?
Please check that you haven't given same foreign key name to multiple relations, if yes then make it unique. Also check that the data types are same in both tables.
You got the right answer sanchit. Thanks for the directions.
Please consider marking the answer as correct so that anyone else having the same issue in future can find this working solution.