Deleted records

[Guest]

Is there some way to notify a table, that logs data entery events, that a
record has been deleted from some other table? I have a hidden form that is
populated with the data the user enters or deletes from their data entry
form's objects. Now, there is a problem with users deleting records and the
need is to record a record being deleted.

 

[chriske911]

JimN wrote on 14/09/2006 :

Is there some way to notify a table, that logs data entery events, that a
record has been deleted from some other table? I have a hidden form that is
populated with the data the user enters or deletes from their data entry
form's objects. Now, there is a problem with users deleting records and the
need is to record a record being deleted.

create a custom delete button and prohibit the use of the builtin
toolbars
that way you could cook up an event that either flags a record as being
deleted (i.e. a boolean field set to true)
or move the record to an archive table and add the current user value
to a deleted_by field in the same archive table
or any combination of the examples given

grtz

 

[Guest]

Thanks, your answer really helps!
Jim

JimN wrote on 14/09/2006 :

create a custom delete button and prohibit the use of the builtin
toolbars
that way you could cook up an event that either flags a record as being
deleted (i.e. a boolean field set to true)
or move the record to an archive table and add the current user value
to a deleted_by field in the same archive table
or any combination of the examples given

grtz