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?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
vanderLeest
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?
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.