Hi All,
I have 2 tables TABLE1 and TABLE1_HISTORY. I need to combine latest 1 row from TABLE1 and few historical rows from TABLE1_HISTORY and display the values in a single grid.
Instead of using UNION to combine the 2 tables using DB views or querying the 2 tables separately and combine in Appian side , is there a way to union 2 tables using recordtypes ? relationship creation is not working as the PK / FK relationship doesn't exist.
Note Here: As per our current design , the common field between the 2 tables are not a PK field in either of the tables because of which i am not able to create relationship as join / union in SQL.
Appreciate the suggestions. Thanks in advance
Raj
Discussion posts and replies are publicly visible
Hi Mathurama,
Thanks for the response , when you make the common field in TABLE 1 as unique , the same field is not unique in TableHistory . here the relation ship must 1 to many right. Might be i need to rethink of redisgn the table.
Thanks again
without relationships created , we will not be able to use from both tables in same customfield. When tried i got error. My issue is creating relationship between 2 tables on non pk's. Thanks for the response
yes it can work, but it is convoluted.