>When you say it's still, what does that mean? Is DELETED set OFF? If so, you'll still see it, but it'll be marked as deleted. Could that be what's going on?

Hi Granor. My trouble is fixed. :)

You're clue about RI helped on your first reply.

The problem was my RI was not setup correctly, thus, the trigger failed and the delete statement did not work properly. So, I removed all the involved tables from the database, and started all over. Fortunately, there are only 4 tables that I needed to redo.

Thanks for your reply.