You might need to rewrite the trigger. That error cannot magically go away, you need to write sub-queries that do not return more than one value.

If you need help, you need to post code.