I have Master and Detail TMSQuery.
I set (at design time)
Code: Select all
Detail.MasterSource := Master
Detail.MasterField := Master_ID
Detail.DetailField := Master_ID
There was an Order by Master_ID in the Detail query, but I remoevd it.
Code: Select all
Detail.MasterSource := Master
Detail.MasterField := Master_ID
Detail.DetailField := Master_ID
Code: Select all
Detail.DetailField := DetailTableName.Master_ID
Code: Select all
SELECT
EDE.ID_EVENTO,
EDE.ID_ATTIVITA,
EA.NRO_RIGA AS TASK_NO
FROM
EVA_DOMANDE_EVENTO EDE
LEFT OUTER JOIN EVA_ATTIVITA EA ON EDE.ID_ATTIVITA = EA.ID_ATTIVITA
WHERE
EDE.ID_EVENTO = :ID_EVENTO
ORDER BY
EDE.ID_ATTIVITA, EDE.NRO_RIGA