Well I still have not fixed it but have discovered a few other problems that I think are probably all related to same issue.
After configuring using internal_table_manager, I tried using the update and even when all required fields are filled in (I've set 4 as required) I get:
You haven't filled out some required fields.
Please go back and fill all the required fields.
Anyway I started looking at the code (I'm a PHP newb' so bare with me) and inserted a debug print statement in the search (see below "my debug code") and it looks like the $sql variable is not getting set but it looks to me like it should be??
### form.php code snippet ###
case "search":
// build the select query
if (!isset($sql)){ // otherwise we have the $sql from navigation buttons 1 2 3 etc
echo "<b>SQL not set</b>"; //my debug code
$select_without_limit = build_select_query($HTTP_POST_VARS, $conn, $db_name, $table_name, $table_internal_name, $records_per_page, $page);
} // end if
else{
$select_without_limit = "select * from ".$quote."$table_name".$quote."";
if ($sql != ""){
$select_without_limit .= $sql;
} // end if
} // end else
### end of form.php code snippet ###
I'm still at a loss but thought that this additional info might turn a light on for someone less clueless than I.
Thanks.