Table_1 Id int title varchar caption varchar Table_2 Id int Master_Id int title varchar caption varchar 用Table_2的Master_Id关联Table_1的ID
中间层有adoquery1,adoquery2 adoquery1的SQL:select * from Table_1 adoquery2的SQL: select * from Table_2 where Master_Id=:Id adoquery1,adoquery2对应表示层的二个clientdataset1,clientdataset2
Id int
title varchar
caption varchar Table_2
Id int
Master_Id int
title varchar
caption varchar 用Table_2的Master_Id关联Table_1的ID
adoquery1的SQL:select * from Table_1
adoquery2的SQL:
select * from Table_2
where Master_Id=:Id
adoquery1,adoquery2对应表示层的二个clientdataset1,clientdataset2