delete data from database

[Dvorak]

Hi,
Let's say i have two tables,

table_one;
userid,userinput,indexno

table_two;
cond,qant,amp,indexno

the indexno in table_one and table_two are the same.if i choose to delete one row of data in table_one,i want the data with the same indexno in table_two be deleted as well.
how can i achieve this?

[bogu]

U dont need to open the same thread in two diffrent places, if u posted in the wrong section ask mods to move your post ...