kpcollier 24 Report post Posted November 1 Does anyone have a workaround for getting the value of a List DataType to insert into a new table via trigger? Quote Share this post Link to post Share on other sites
0 Andrew 12 Report post Posted Wednesday at 10:26 AM @kpcollier Hello! As I know, there is no any workaround on this case. However, you can use additional table to create many to many relationship and use the values from this additional table as the set to be copied by trigger. Example: Each table from example contains 2 fields. You have some users: 1 - Andy 2- Mark You have some categories: a - cat_1 b - cat_2 c - cat_3 Connection table with id's from previous tables should look like: 1 -a 1- b 1- c 2 - a 2 - b 2 - c You can create the trigger to copy entire categories set and insert in in the connection table with id of newly inserted user. Quote Share this post Link to post Share on other sites
Does anyone have a workaround for getting the value of a List DataType to insert into a new table via trigger?
Share this post
Link to post
Share on other sites