What have you tried so far for your trigger?

Also, you are going to have a problem with your "RENTED" table. You have a primary key on "DUEDATE". This will prevent any two instruments from being due on the same date.

Andy