Show child rows depending on focus in mother table

Hi Pnoindl,
Please have a look at the attached example.
Form1.tablegrid1 shows your invoice headers.
Form1.tablegrid2 shows your invoice lines related to the invoice header row that has been highlighted
The way you link the two tablegrids is by using a button defined with a 'search' action (in my example, this is button4).
Button4 uses form1.tablegrid1 as its search criteria - in other words, whichever row is highlighted in tablegrid1 will display the related child records (invoicelines) in tablegrid2 when form1.button4 is clicked.
To make it more user-friendly, button4 can be hidden and automatically clicked (an 'incremental search'), whenever a different row in form1.tablegrid1 is highlighted - see the screenshot in the attachment to see how this is done.
This is standard MVD functionality and needs no script.
Regards,
Derek.

Hi,
Yes, you can remap any keys you want.
For function keys, please have a look at the attached example (Fkey codes are in the script).
Regards,
Derek.

Hi,
Calculated fields are not held in tables, they only exist temporarily as the result of a calculation when your program runs.
In your example, 'price' is held in your invoiceline table and 'quantity' is held in your invoiceline table, but 'linevalue' does not need to be stored in your invoiceline table - it is derived by the calculation of 'price' * 'quantity'.
For this reason, If you use 'reportsql', you can't reference calculated fields because they do not exist! 
However, you simply need to replicate the formula to calculate the linevalue inside your reportsql if you need to see linevalue.
Have a look at the attachment.
Derek.