remove record from database

[nelsonmb]

hy

I have in my database 2 tables and after create de code to insert and update the next is remove. My question is what is the best way when i remove one record in the main table to remove also in the second table.

Can anyone help me to guide or give me one ideia how to do it..

thanks

Nelson MB

[paulnaj]

Hi nelsonmb,

Only way is to use two DELETE sql statements. I usually delete from the detail table first, but that's just my pref.

Paul 🙂

[nelsonmb]

well, you mean delete the main table first and after the other!!! i supose that the record in the main table was the last to delete....!!!???