Hi ,
i was wondering if possibly to add a custom look up field on grid area .
that field will look up the value of a table named template .
one is selected by the user to autofill fields of the row same with values from table template.
i.e. template table have the fields
field1
field2
field3
i want to a add a custom look up field on the grid area of the inline edit page called
field4 ( field4 will lookup field3 of the template table)
once is selected a value to get the values of field2 and field3 and fill the value of the row of another two fields named field5 and field6
pls help
P.S SOMETHING LIKE THAT
$str = "";
$str.= "<select onchange=\"window.location.href=this.options[this.selectedIndex].
value;\"><option value=\"\">Please select</option>";
//select values from database
global $conn;
$strSQL = "select airport from airports ORDER BY airport";
$rs = db_query($strSQL,$conn);
while ($data = db_fetch_array($rs))
$str.="<option value=\"rates_list.php?a=search&value=1&SearchFor=".$data["airport"].
"&SearchOption=Contains&SearchField=origin\">".$data["airport"]."</option>";
$str.="</select>";
echo $str;
BUT TO ADD THE LOOKUP TO GRID AREA AND NOT SEARCH BUT INSERT FIELDS
OR FURTHR MORE I WISH TO ADD THE DRAGDROP FROM TABLE TEMPLATE TO CURRENT ROW OF EDITABLE TABLE HOURS
http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxdragdrop/index.htm?%28classic%29#demos/jqxdragdrop/defaultfunctionality.htm
MY TABLES IMAGES BELOW
I NEED THAT TABL1 TO BE DRAGABLE TO TABLE 2 TO AUTOFILL EQUIVALENT VALUES
SOMEONE CAN HELP?