ALTER TABLE  `SC_products` ADD  `supplierID` INT NOT NULL , ADD  `locationID` INT NOT NUL;
CREATE TABLE IF NOT EXISTS `SC_locations` (  `location_id` int(11) NOT NULL auto_increment,  `name` varchar(30) NOT NULL,  `comment` text NOT NULL,  PRIMARY KEY  (`location_id`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
CREATE TABLE IF NOT EXISTS `SC_suppliers` (  `supplier_id` int(11) NOT NULL auto_increment,  `name` varchar(30) NOT NULL,  `comment` text NOT NULL,  PRIMARY KEY  (`supplier_id`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

/// Получает список поставщиков
function get_suppliers()
{
    $sql = 'SELECT * FROM SC_suppliers';
    $res = db_phquery_fetch(DBRFETCH_ROW_ALL, $sql);
    return $res;
}
/// Получает список мест
function get_locations()
{
    $sql = 'SELECT * FROM SC_locations';
    $res = db_phquery_fetch(DBRFETCH_ROW_ALL, $sql);
    return $res;
}

//Список поставщиков
        $suppliers = prdsetActions::get_suppliers();
        $smarty->assign( 'suppliers', $suppliers);
//Список мест
        $locations = prdsetActions::get_locations();
        $smarty->assign( 'locations', $locations);

/// Получает данные одного поставщика
function get_supplier($supplier_id)
{
    $sql = 'SELECT * FROM SC_suppliers WHERE `supplier_id`='.$supplier_id;
    $res = db_query( $sql);
    $row = db_fetch_row($res);
    return $row;
}
/// Получает данные одного места
function get_location($location_id)
{
    $sql = 'SELECT * FROM SC_locations WHERE `location_id`='.$location_id;
    $res = db_query( $sql);
    $row = db_fetch_row($res);
    return $row;
}

<tr>
    <td>{'lbl_actual_location'|translate}:</td>
    <td>
        <select name="locationID">
          {foreach from=$locations item=_location}
            <option value="{$_location.location_id}" {if $product.locationID == $_location.location_id}selected="selected"{/if}>{$_location.name}</option>
          {/foreach}
          </select>
    </td>
</tr>
<tr>
    <td>{'lbl_supplier'|translate}:</td>
    <td>
        <select name="supplierID">
            {foreach from=$suppliers item=_supplier}
                  <option value="{$_supplier.supplier_id}" {if $product.supplierID == $_supplier.supplier_id}selected="selected"{/if}>{$_supplier.name}</option>
              {/foreach}
        </select>
    </td>
</tr>

var $locationID;
var $supplierID;

$gridEntry->registerHeader("lbl_supplier", 'supplier', false, 'desc');
        $gridEntry->registerHeader("lbl_location", 'location', false, 'desc');

<td><a href='{$product_url}' title="{$GridRows[i].supplierComment}">{$GridRows[i].supplierName}</a></td>
                <td><a href='{$product_url}' title="{$GridRows[i].locationComment}">{$GridRows[i].locationName}</a></td>

$where_clause = str_ireplace('WHERE ', 'WHERE ( ', $where_clause).')';

s.name AS supplierName, s.comment AS supplierComment , l.name AS locationName, l.comment AS locationComment

 '.TBL_SUPPLIERS_LIST.' AS s , '.TBL_LOCATIONS_LIST.' AS l,

'AND s.supplier_id = p.supplierID AND l.location_id = p.locationID  '.

INSERT INTO `SC_division_interface` (`xDivisionID`, `xInterface`, `xPriority`, `xInheritable`) VALUES
(211, '58_manage_locations', 0, 0),
(212, '59_manage_suppliers', 0, 0);
INSERT INTO `SC_modules` (`ModuleID`, `ModuleVersion`, `ModuleClassName`, `ModuleClassFile`) VALUES
(36, 1, 'locations_list', '/locations_list/class.locations_list.php'),
(37, 1, 'suppliers_list', '/suppliers_list/class.suppliers_list.php');
INSERT INTO `SC_divisions` (`xID`, `xName`, `xKey`, `xUnicKey`, `xParentID`, `xEnabled`, `xPriority`, `xTemplate`, `xLinkDivisionUKey`) VALUES
(211, 'pgn_locations', '', 'locations_list', 10, 1, 4, '', ''),
(212, 'pgn_suppliers', '', 'suppliers_list', 10, 1, 3, '', '');
INSERT INTO `SC_module_configs` (`ModuleConfigID`, `ModuleID`, `ConfigKey`, `ConfigTitle`, `ConfigDescr`, `ConfigInit`, `ConfigEnabled`) VALUES
(58, 36, 'locations_list', '', 'Locations', 1002, 1),
(59, 37, 'suppliers_list', '', 'Suppliers', 1002, 1);

define('TBL_SUPPLIERS_LIST', DBTABLE_PREFIX.'suppliers');
define('TBL_LOCATIONS_LIST', DBTABLE_PREFIX.'locations');