Tracking Changes ( added records, deleted records, change in record)

[karpartz]

I have a table that is updated each week and I need to identify the changes to the table each week as an added record, or a deleted record or a change in status to a field for the pdd and or the shortage filed. I am trying to show changes between two tables on a weekly basis and I need to show when there has been a record added, a record deleted or a change in data for one field pdd. I then need to identify them as added record, changed record or removed record. My tables are Long Term BO Changes and the fileds are
DDC, text
Manufacturer text
Sales Number
Shortage text
Root Cause text
Date Placed on list Date
pdd text
Date Date
Added text
Changed text
Removed Text

I am only looking for changes to the DDC is not the primary key because it may be on the list more than once due to the data feed which may have the name of the mfg entered different ways. We will work on this discrepancy to clear it up. Is there a SQL that will look for additions and deletions and changes to these fields.

 

[MichaelRed]

Ms. A. (Jet) does not have record level triggers, or even table level triggers, so there is no SQL for this. If you can restrict the changes to being done via a form, there are posabilities, but your post seems to indicate that you receieve the new table as an object, not as a set of updates, so no help from the forms either.




MichaelRed

 

[Crowley16]

the only thing you can do is to add more columns to the table which store dates of changes and fields changed and stuff...

then when you change a record, you need to make sure these fields are filled out...

this assumes you use a script/procedure to change the table values which you can get at.

if you're doing a straight import/update then there's no chance.

--------------------
Procrastinate Now!