Kæde en anden tabel i en sletteforespørgsel

DELETE tabel1.* FROM Tabel1, Tabel2...

if the joined table is related then you can go in the relationships window and modify the relationship so that cascade deletes are allowed then you only need to delete theone table and the related records get deleted automaticaly

Nåh... Men jeg kan ikke huske, hvordan jeg sætte relationen, til at opdatere kaskadevis...

Har fundet det...

MENU: Funktioner - Relationer
Dobbeltklik på relationen, og angiv kaskadevis sletning.

Hmmm..... I den ene tabel, er nøglen autonummering, og i det andet er det tal. Jeg kan ikke rigtig ændre det...

This is OK!
In the table where it is an autonumber this is the primary (unique) key, for example in an Order.
In the table where it is a number it is the foreign key, for example in an Order Detail.

If you delete an order you want to delete alll order details.

So drag the field from the primary key side to the foreign key side and then the two fields will have a line going between them. Right click on the line and select Edit Relationships. Then select Enforce Referentail Integrity and Cascade Delete Related Records.

An autonumber IS also a number!