MRT update page (nearly there?)
After getting to grips with a MRT insert, I am having a bit of difficulty with the update page.
On the update page, I need a recordset to recover the appropriate values from the relational table to set the check box values.
I need to work out the recordset required in order to return all rows from the ‘options’ table, with appropriate values for the relevant checkboxes to be checked
I have tried left joining the options table to the relational table, hoping to get all options, but as soon as I introduce the url parameter, i don’t get the result.
I'm sure the answer is starting me in the face, but i can't work it out