sletteforespørgsel på flere tabeller

Yes,
CASCADE DELETE RELATED RECORDS in Relationship window

Yo have to choose Enfore Referential Integrity and then
Cascade Delete ....

Lav istedet 2 sletteforespørgsler. Der skal nemllig slettes fra den ene før der kan slettes fra den anden.

Der skal slettes fra den med mange først.
Vh Henrik

Hvis man sletter fra den En side vil alle fra mange siden slettes automatiske!
Ingen brug for sletteforespørgsler :o)

Hvis man bruger CASCADE DELETE RELATED RECORDS er det IKKE nødvendigt at slette alle fra den mange side først!

Og hvis det er nødvendigt, så er det fordi dine relationer er forkært :o)

sorry guys, det er ikke det vi vil!! vi skal KUN slette fra en siden, og vi har lavet kaskadevis sletning til andre relaterede tabeller.

?
You got me there! What is the point in deleting from the one side (primary key) and your many side (foreign key) still exists?

Your working AGAINST the principles of relational databases!

If you MUST delete the one side then you have no need for the relationship!

and?

man I wish I could just show you...it's pretty complicated...I know it sounds ludicrous...it's because we wanted to find records that were present on the many side but not on the one...our client's data was all wrong...anyway! we ended up deleting all the conflicting records by hand cause there weren't THAT many records...

it's the end of a looooong day :-)

If you have your relationships in order you should NOT be able to add a record in the many side UNLESS it is on the one side!
Take a look at referential integrity in the lationships window