Jump to content
  • 0

Workaround For Multi Select List Types In Trigger



1 answer to this question

Recommended Posts

  • 0


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.

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.


Link to comment
Share on other sites

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.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...