Multiple Updates

have a table created from dataassist and one field in the table for the user to update which is a status field. update this field and submit the form and all the records get updated - so this works fine

I have a standard update form (same sort of thing) update status field and this will update the single record but will also update a log field which appends the status to the log field.

I want to include this in the table, so when each record is updated it also updates the history field. however as in the standard update form the history will not get updated if the status field has not changed, ie is the same as what is in the recordset or variable set from the recordset

hope this makes sense

in the standard form I have a seperate trigger update section with the setup (see below), I copied this to the table with some adjustments to the trigger statement and still no luck

any suggestions how I update this on the multi update page and also include the hist field in the WA multi section..?


this is what I have in the standard update form

<?php
// WA Application Builder Update
if (isset($_POST["Update_x"])) // Trigger
{
if ($_POST['currentupd'] != $row_WADAtbldmtask['taskupd']) {
$histnew = (date("dS M Y H:i")." - ".$who." ".$iam." - ".$_POST['currentupd']);
$histold = ($row_WADAtbldmtask['taskhist']);

$hist = nl2br($histnew."\r\n".$histold);
}
if ($_POST['currentupd'] == $row_WADAtbldmtask['taskupd']) {
$hist = ($row_WADAtbldmtask['taskhist']);
}
}
?>

this will take some rather complex coding to accomplish and is beyond what we can help you with here in the forum.

I would suggest signing up for a premiere support ticket appointment where we could work with you in a one on one screen sharing session to implement this.

thanks for the offer and agree as its seems complex I'll look at other ways of doing this. if I find a solution I'll post it up for anyone else who maybe interested.