By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,325 Members | 1,920 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,325 IT Pros & Developers. It's quick & easy.

delete same entry from different tables

P: n/a
I have a form that I have subforms in. I have set up relationships between
all tables for cascading delete so that once I delete from the main table it
should delete the entry that shares the relationship in the other tables as
well. It's not.

I know I am doing this wrong but I don't know what I am doing wrong to fix it.
Please help.

If I am not being precise enough please ask questions so that I can explain
myself better.

--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200712/1

Dec 14 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi Scot,

Most Likely there are dependencies on either the detail or the master
tables (dependent relationships). What I would do is to create a simple
model of a master table and detail table and populate it with fake data
(like 10 records in the mock Master table and 30-40 records in the mock
detail table). So you only have the 2 tables for sure in this model and
then relate them with cascade delete/updates. Then perform a Delete on
the mock master table. The mock detail table should also delete a
record. If this model is working correctly on the mdb then you know
that the rdbms model works. Now investigate your actual tables.

I would make a copy of the mdb, actually, and create your test tables
there. Then take the actual tables in the copy mdb and remove
relationships and try your deletes with only one table related.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Dec 14 '07 #2

P: n/a
Thank you very much Rich!!!

Rich P wrote:
>Hi Scot,

Most Likely there are dependencies on either the detail or the master
tables (dependent relationships). What I would do is to create a simple
model of a master table and detail table and populate it with fake data
(like 10 records in the mock Master table and 30-40 records in the mock
detail table). So you only have the 2 tables for sure in this model and
then relate them with cascade delete/updates. Then perform a Delete on
the mock master table. The mock detail table should also delete a
record. If this model is working correctly on the mdb then you know
that the rdbms model works. Now investigate your actual tables.

I would make a copy of the mdb, actually, and create your test tables
there. Then take the actual tables in the copy mdb and remove
relationships and try your deletes with only one table related.

Rich
--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200712/1

Dec 17 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.