Jump to content
  • 0

trigger for many to many connector table


Sam23
 Share

Question

I have a many to many connector table: Contact x CT1 that connects Contacts to groups in CT1. I would like a trigger on the Contact table such that when a record is updated, it checks to see whether there is a record in the Contact x CT1 table with the inserted ContactID and CT1. The CT1 is temporarily stored in the Contact table when a record is added.

I am looking for a record in the Contact x CT1 where there is a double match: both the ContactID and the CT1 from the inserted. Here is what I have so far, but I am getting duplicates in the ContactxCT1 connector table with

this:

 408176721_ScreenShot2021-10-21at1_24_56PM.png.694915d77ad06cd23eea649eb9a228d8.png

 

1622639496_ScreenShot2021-10-21at1_41_08PM.thumb.png.dd7a0daffb010581708477a87bbbb005.png

Thank you!!

 

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

May I request a better screenshot of the trigger?

I think you are just getting confused with the lineup.

First, how many tables are involved?

Which among them is the main table (where the trigger is residing)

After that, lets compare it with your actual intended workflow. PErhaps after that we can provide further suggestions

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.

Guest
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.

Loading...
 Share

×
×
  • Create New...