|
1.
Consider This: Should You Delete Data? Deleting
data is not a good idea in a relational database. When you create a
Receipt in our database, you need information from five Tables.
Consider this scenario. Say you
deleted the Movie, "Brave" from tblMovies. Say the Primary Key,
MovieID, for this Movie was 407. Now, you
want to run a Report that looks up all of the Receipts. Any Receipt
that had MovieID 407 will be incomplete. There is no data because
that Key is missing. This is
not good. The
preferred method is to Archive a Record by marking it as Archived, Done or
Obsolete.
Microsoft Access: Example of the warning
message when
a Record is deleted
|
|
| |
