My products need a listing of manufacturer and OEM numbers on the product page. A product may have none or may have 30 OEM numbers to list.

I created a new table named products_oem with the fields products_id (matches products_id from the products table), manufacturers_id, and oem. This table has a record for each oem number for each product, so some products will have several matching records in this new table.

Now this is where I'm stuck... how can I pull this information into the product listing and make the oem numbers searchable?