You could use this function to look up the manufacturers_name by the products_id ...
Code:
/*
 * Return a product's manufacturer's name, from ID
 * TABLES: products, manufacturers
 */
  function zen_get_products_manufacturers_name($product_id) {
Just look for how the products_id is referenced in that module ...