delete same entry from different tables

[spcscooter via AccessMonster.com]

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

[Rich P]

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 ***

[spcscooter via AccessMonster.com]

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