Help with dataprocessor

Suite and Optimus Suite 5
#1

I have 3 mySQL tables:

TBL_Contractors C_ID (Primary Index) - Rowselected ID
TBL_Tools T_ID (Primary Index) - Used as select box in Grid
TBL_Tool_Allocation C_ID, T_ID

I need to display the tool allocation table based on selected contractor(C_ID) and the tools allocated (T_ID) in a Grid. How do I pass the two ID’s for the filter. I can’t seem to find it anywhere.

Also how can I pass the two ID’s to save the data on changes.

Any help would be great thanks in advance.

#2
<?php require_once("../codebase/connector/grid_connector.php");// includes the appropriate connector require_once("../codebase/connector/options_connector.php");// includes the appropriate connector $res=mysql_connect("localhost","","");//connects to a server that contains the desired DB mysql_select_db("dmn_crm");// connects to the DB. 'dmn_crm' is the name of our DB $options = new SelectOptionsConnector($res); $options->render_table("TBL_TOOLS","ID","ID(value),TOOL(label)") $conn = new GridConnector($res,"MySQL");// connector initialization $conn->set_options("T_ID", $options); $conn->render_table("TBL_TOOLS_ALLOCATION","ID","T_ID,C_ID,MAKE,MODEL,SERIAL,ALLOCATED,RETURNED");// data configuration ?>

This does display a combo box when I add a new row to enter data…

#3

Ignore the above.

I had to include the connector.js and dataprocessor.js.

All is working fine. Thanks