I am creating an editable report with an update-set-where sql statement, but when a user clicks on an edit button and it pops up the edit report I want the current values of the row the user selected when they click the edit button. I created the default value parameter query without the where clause, but it will only show the data from the very first row no matter what the user clicks. Is there a way I can set the 'ID' variable in the where clause of a default value parameter query? Everytime I do set a variable in the where clause it gives me an error:
DB error (1054): Unknown column 'vKey' in 'where clause'
SQL: select xxxx from xxxx where xxx = vKey