Delte Record Query?

[fenhow]

Hi, I have two tables joined by PK. The form has Main and Sub. One Main can have many Subs.

I am trying to create a macro or Query that will delete a record the problem I am having is if i delete a record from table 1 (Main) the data in the table 2 (Sub) stays in the DB.

Can anyone tell me how to delete a record and the sub records at the same time?

Thanks.

Fen How

 

[KenHigg]

Do you have the cascade deletes set up in the relationships window?

 

[fenhow]

No, should i do that? How do i do that?
Thanks

 

[KenHigg]

Hum... That's kind of MS Access 101. Here's a link to get you started:

http://databases.about.com/od/tutorials/l/aarelationship1.htm

 

[fenhow]

thanks, it will not let me do it as it says it violates integrity rules, the DB is a one to many with the PK in Main table autonumber.

Thanks.

Fen