Search the Community
Showing results for tags 'select distinct'.
I aim to add unique values in a support table on which I hope to build a graphical report On Insert into the T_EA_Entities table (which is child table linked to the main Activities table, and data is entered via a child form on the Activity Data Page) I want to insert unique Entity IDs associated with the Activity stored in a separate table called T_EA_Entities_Unique. NB: T-EA_Entities stores nect to Entities also sometimes multiple contact persons for an entity (= multiple records) I have attached the Trigger Action. This Action only adds one Entity ID to the T_EA_Entities_Unique table, instead of the multiple who are entered via the DataPage in the T_EA_Entities table. Does anyone have an idea how to modify the Trigger Action so it will add multiple values to the table?