See below.
I trigger a record to be inserted into the renewedlog_invoice when a record is tagged as renewed in the insurancehouse_members_db table.
If the record is updated twice two entry are made in the Renewedlog_Invoice Table.
Rather than a second record being inserted into the Renewedlog_Invoice Table I would prefer it update the first record that was created when it first triggered.
I think similar Place works issue above your
Have you tried the comparison type, "NOT IN"?
May fix this for me???
Many Thanks for your help