[How To] Editable grid field select with filtering based on data column value

  
part_id         part_num                 parent_part_num  
1                   1234                         0  
2                   SUB 1                      1234  
3                   SUB 2                      1234  
4                   2345                         0  
5                   NEW SUB 1            2345  
6                   NEW SUB 2            2345  

   $db = new clsDBmentecky();  
   $SQL = "SELECT * FROM parts WHERE parent_part_num = ".$parts->ds->ToSQL($parts->ds->f('part_num'), ccsText);  
   $db->query($SQL);  
   $Result = $db->next_record();  
  
   $options = "";  
  
   while ($Result)   
   {  
      // Add a Value, Text pair  
      $options[] = array($db->f('part_num'), $db->f('part_num'));  
      $Result = $db->next_record();  
   }  
  
   $db->close();  
  
   $parts->subassembly->Values = $options;  

  
Reworked to match my setup  
part_id		part_num	parent_part_num		JobId  
1		1234		NULL			1  
2		SUB 1		1234			1  
3		SUB 2		SUB 1			1  
4		2345		NULL			2  
5		SUB 1		2345			2  
6		SUB 2		SUB 2			2  

  
<row_1>  
<select id="part_1234_possible_parents" >  
   <option value="2">SUB 1</option>  
   <option value="3">SUB 2</option>  
</select>  
</row_1>  
  
<row_2>  
<select id="part_SUB 1_possible_parents" >  
   <option value="1">1234</option>  
   <option value="3">SUB 2</option>  
</select>  
</row_2>  
  
<row_3>  
<select id="part_SUB 2_possible_parents" >  
   <option value="1">1234</option>  
   <option value="2">SUB 1</option>  
</select>  
</row_3>  

Quote :

function getCategoriesList($link_category_id="0", $prefix="")
{
$values = "";

$db = new clsDBcommunity();

// Get counts for all sub categories
$SQL = "SELECT * FROM link_categories WHERE link_category_parent=$link_category_id ORDER BY link_category";

$db->query($SQL);

$result = $db->next_record();

while ($result)
{
$subvals = "";

// Add this category
$link_cat_id = $db->f("link_category_id");
$link_category = $db->f("link_category");

$values[] = array($link_cat_id, $prefix.$link_category);

$subvals = getCategoriesList($link_cat_id, $prefix.$link_category." - ");

for ($i=0; $i < count($subvals); $i++)
{
if (!empty($subvals[$i]))
{
$values[] = $subvals[$i];
}
}

$result = $db->next_record();
}

return $values;
}

  
function vwjobsubassemblies_BeforeShowRow(& $sender)  
{  
    $vwjobsubassemblies_BeforeShowRow = true;  
    $Component = & $sender;  
    $Container = & CCGetParentContainer($sender);  
    global $vwjobsubassemblies; //Compatibility  
  
//Custom Code @841-2A29BDB7  
// -------------------------  
   $DBConnection = new clsDBConnection1();    
   //query that gets all the current job sub assembly part numbers but excludes the current row part number  
   $SQL = "SELECT * FROM JobSubassembly WHERE PartCode <> ".$vwjobsubassemblies->DataSource->ToSQL($vwjobsubassemblies->DataSource->f('PartCode'), ccsText)." AND JobId = ".CCGetFromGet("JobId");    
   $DBConnection->query($SQL);    
   $Result = $DBConnection->next_record();    
    
   $options = array();    
    
   while ($Result)     
   {    
      // Add a Value, Text pair    
      $options[] = array($DBConnection->f('PartCode'), $DBConnection->f('PartCode'));    
      $Result = $DBConnection->next_record();    
   }    
    
   $DBConnection->close();    
    
   $vwjobsubassemblies->HeadSubPartCode->Values = $options;    
// -------------------------  
//End Custom Code  
  
    return $vwjobsubassemblies_BeforeShowRow;  
}