Topic: How to SQL from a parent grid.
Hi, as I am now up to the point of learning how SQL works, my question is probably very basic but part of the learning curve.
I seem unable to find how you search for an individual from a parent grid.
I am trying to sort info form a table using a "Client name" that has been selected in an earlier grid/form.
See my pic for a visual example and here is my script.
form2.totalExpense.Value := SQLExecute('SELECT TOTAL(amount) FROM expense WHERE 'Status' = "expense" AND ???? Name of client on form matches id of table expense ????? ');