grid问题求助

Question

2个DBGRID表,使用了adoquery的主副明细分开,想在主明细表里删除一项后,对应的副明细表里的的项全部删除,请问该如何删除

Answer 1

delete from DetailNmae where DetailNmae.MasterID=Master.MasterID

Answer 2

先删从表adotable2，再删主表adotable1
with adottable2 do
  begin
    while not eof do
      begin
        delete;
      end;
  end;
adotable1.delete;