DELETE RECORDS from RELATIOAL DATABASE

[Charlix]

Hi,
I have been unable to delete cetain records from a relational MS Access database.I can delete those records where there is a one-to-one relation between the primary and foreign table BUT I can not detlet the records from the primary table where there is a one-to-many relation. I get the error\
**************
"can not delete since there are related records in other tables"
**************

Even if I remove the records in the foreign table, I still get the error message when I try to delete the primary table record.

How can I code my asp page to allow me to delete records remotely?

Thanks,

Charlix

 

[vongrunt]

> Even if I remove the records in the foreign table, I still get the error message when I try to delete the primary table record.

Then there must be some other relationships that restrict DELETE action.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[Charlix]

Thanks vongrunt,
There are other relationships and these must be restricting the delete.

I'm trying to analyze my database to see what I can do. Unfortunately, I don't know how to remove the relationship between the tables prgramatically so that I can edit the tables from a web page.

Charlix