What record were appended? 1

[DajOne]

Is there a way to track which record were appended to a table and produce a report or store the key of the records appended into a table?

Thanks

Yvan

 

[nomus1]

An easy way to do this might be to add a time field to the table.

Then you could run your report based on the time the information was added to the table.

You could also add the user ID and then you could additionally report based on who added the record.

 

[Quehay]

If all the records are appended nomus has your best answer. If some are appended, while others are entered through forms you could have a boolean "Appended" field that's set to TRUE on all INSERTS. Jeff Roberts
Analysis, Design, & Implementation
RenaissanceData.com