Posted by mike on 04/21/06 18:58

I have a SQL based ERP package. Now I am having an issue on a
particular table of people deleting a record (in the ERP system) and no
one having any idea of who did it or when.

So I thought I would setup a delete trigger so that when a record is
deleted from a table it would populate a new table that I created with
some information, doc_no, date etc... My problem is how can I get the
new table to populate only information for the record being deleted.

I did one try and it populated it with all remaining records. Ok I see
my logic error, but realized that I don't know how or if I can populate
it with info from the record being deleted.

Thanks in advance.

• Next in forum: Strange issue with SQL Table read only in Access
• Prev in forum: [ANNOUNCE] Learn XSL by Example
• Thread view: Trigger Question

[Reply to this message]