How to link tables in ADOQuery in Delphi?

Question

Delphi

There is no Mastersource property in ADOQuery, how to link three tables? One of them is the main table with the key field Key, and the other two tables are subordinate. Each of these tables has a key field Product.
The action should be like this: for example, the user clicks on a record in table 1, and the data of this record is displayed in table 2

Answer 1

For the master table, handle the AfterScroll event, something like this:
Master query
Detail query

procedure TForm1.ADOQuery1AfterScroll(DataSet: TDataSet);
begin
  ADOQuery2.Close;
  ADOQuery2.Parameters[0].Value := ADOQuery1.FieldByName('id').Value;
  ADOQuery2.Open;
end;

Try something like this