If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
cascade delete problem
When I delete customer info from a linked table, the customer info is removed
from the other tables in the database. I need to be able to delete old customer info in the linked table but keep the cutomer info in the other tables. I am using a lookup table to get customer info from the linked table. Cascade delete is not checked. The Database is Access 97. Thanks. |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Could you or somebody recommend a creative solution to this problem? I am
stuck with the present basic design of the DB. Thanks. |
#4
|
|||
|
|||
"Tonymac12" wrote in message
... Could you or somebody recommend a creative solution to this problem? I am stuck with the present basic design of the DB. Thanks. Add a Yes/No field that you can use to "mark" them deleted without actually deleting them. On new records you can filter out the "deleted" choices, but they are still there to support historical records. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I have checked cascade deleted records but when I delete the reco. | R M Starich | General Discussion | 1 | October 9th, 2004 05:12 AM |
Delete Query | Shanin | Running & Setting Up Queries | 14 | July 31st, 2004 07:15 PM |
Deleting Records does not Delete Records | Lucky Man Cree | New Users | 7 | July 6th, 2004 11:33 PM |