C.D.,

Your problem is the UNIQUE indexes. Don't use them! They are not updated as you might expect at all.

If you need a unique list then either create a unique index, use it, and delete it or use SQL SELECT to get the list for you.