Oh, oh, oh, think I've figured this one out. As all the update action takes place in the Update Record. I dived in there and modified the code. I'll post it here as this may be of help to others.
My delete checkbox is:
<input type="checkbox" name="chk_1" value="delete" />
Modified update record code (being careful) from:
|" . "".((isset($_POST["title_1"]))?$_POST["title_1"]:"") ."" . "|
To:
|" . "".((($_POST["chk_1"] != "delete"))&&(isset($_POST["title_1"]))?$_POST["title_1"]:"") ."" . "|
...and what do you know, it seems to work !!
So only if the checkbox is ticked is the 'title' entry deleted from the database field.
The code below was found on this good forum posted by Jason. I'll paraphrase here.
When it comes to deleting the file's name from the database (using the same checkbox):
The modification is made to the line 'DefaultFileName... and don't forget the correct path to your files folder in 'UploadFolder''
$WA_UploadResult1_Params["WA_UploadResult1_1"] = array(
'UploadFolder' => "../uploads/",
'FileName' => "[FileName]",
'DefaultFileName' => "".((($_POST["chk_1"] != "delete"))?$_POST["file_1"]:"") ."",
'ResizeType' => "0",
'ResizeWidth' => "0",
'ResizeHeight' => "0",
'ResizeFillColor' => "" );
// WA_UploadResult1_1 End
// WA_UploadResult1 Params End?>
To delete the actual file from the server, add this for each checkbox:
<?php
$WA_DeleteFileResult1 = false;
if((((isset($_POST["chk_1"]))?$_POST["chk_1"]:"") != "")){
$WA_DeleteFileResult1 = WA_FileAssist_DeleteFile("../uploads/", "".((isset($_POST["file_1"]))?$_POST["file_1"]:"") ."");
}?>
I just repeated this for all the other files/titles on the page with checkboxes chk_2, chk_3, etc.
I've only just got this working and need to test thoroughly... but so far, so good.
Paul