Hi, i have to do this: "Update a record in another table when inline edit is saved"
TABLE1:id_first,field,field,field,id_second
TABLE2:id_second,field,field,field, free (as chekbox)
When i inlineedit the table one, i get a lookup list of table 2 linked
by id_second, when i select a line of table2 i want to update
the free field (in table 2) to set it as locked (1).
after in where clause i'll put display only id_second where free = 0, so
i can link only the free lines.
i put this code in list page, after record processed, but it isn't very nice...
global $conn;
$rs = db_query($str,$conn);
$i = $values["ID_id_Mappa"];
$strSQLInsert = "select * from magazzino_mappa where id_postomappa='".$i."'(ID_Link_IdArticolo) values ('1')";
db_exec($strSQLInsert,$conn);