Deleting records from table - but leave related information

[Kelly]

Hi,
I have a table with names and e-mail addresses that I need to remove 11 of
the 13 names. There are many tables in the relationship setting.

I was unable to break the relationship between the table initally, so I
thought to do a delete query. That worked, but it also deleted the history of
related information from some other tables.

The employee_table is the table that I needed to remove some names from.
This table is related to (2) other tables in a 'one to many' and (1)
relationship is set to 'cascade related update fields'.
Maybe checkinging the other option "cascade delete related records"? I'm not
sure, but unchecking 'cascade related update fields' came up with a warning
I was thinking that maybe I need to use a query update?

Replacing current transactions with (1) of the names that I'm keepeing would
not be not an issue.

Thank you,

 

[KARL DEWEY]

Maybe checkinging the other option "cascade delete related records"?
That will also delete the history of related information from some other
tables.

The better way is to add an Archive field (Yes/No) to flag when the record
is history. Then in your regular queries have criteria to pull those not
set as archive. The criteria would be 0 (zero) for the Archive Yes/No field.

Have a checkbox way out of the way and only on your main employee
display/entry form bound to the archive field. All your data is available
to run reports even though the employee has departed.

 

[Kelly]

Hi,
(note; I am not real familiar with the design and functions of this database)
That sounds like a good idea, but in this table it includes an e-mail
address that sends out e-mails to all addresses in the table list. It also
looks as though it's been done before becasue of the ID numbering and the
data has emails not currently in the list.
There was a button in the Employee Form for deleting a user, but it doesn't
work.

I will take a closer look in the database and see if I can find something.

Thanks