I have a view which uses the follow query (mySQL) that generates an output from the child table (actions).
SELECT
fkIndex, CID, Address, DateReported, DatePerformed as 'Last Updated', starttime, FieldCondition, FieldStatus
FROM ( SELECT CIDfkIndex, DatePerformed, starttime, FieldCondition, FieldStatus
FROM actions ORDER BY DatePerformed DESC, starttime DESC ) x,
caseheader
WHERE caseheader.fkIndex = x.CIDfkIndex
GROUP BY x.CIDfkIndex
ORDER BY cid desc,1
In the list view, I need to a button to open the related parent with a link such as http://localhost/ServiceDB/actions_list.as...1=3163629%2E462. The goal is to open the master record and also display the related child records.
Thx in advance