Relationship of tables in TADOQuery?

Question

Delphi

Help. I can not establish a relationship between tables. I tried it like with ADOTable - I went to the code editor, clicked diagram, dragged tables and established links by key fields. With TADOQuery it doesn't work that way for some reason - when I try to connect from one table to another, the lines are simply set and that's it, I click on them - zero reaction. If I understand correctly, you need to write SQL queries or how

Answer 1

Well, in general, sometimes you have to write SQL queries.<Sarcasm>
And if it's true, then I understand that this is related to your second question How to link tables in ADOQuery in Delphi?
and since ADOQuery does not have a MasterSource property, the Master-Detail relationship you implement will not work either.
Try using more recent data access components such as FireDac(AnyDac) or UniDac.