-
Set Default on Delete problem
Hello all...
First let me say that these forums are invaluable and it is nice to see people helping each other out.
This is my first message and the problem I have is that I have is with setting a table to do Set Default for all foreign keys when I delete a table.
For example I have two tables that are linked, Donors and Donations. Each Donor has a unique ID (Donor_ID). The Donor_ID is stored in the Donations table as a foreign key to link these tables. When I delete a Donor what I would like it to do is to set all related records in the Donations table to a default value i.e. it would change the Donor_ID in the Donation Table to a "DON1". How do I go about doing this in MS Access? I have seen how it is done in SQL but how do I incorporate this in Access. Please let me know and thank you in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|