Any ideas how I can approach this?

Scenario:

I've 3000 parts & products. If I search for a product X, I want to view all related products or parts to Product X.

EG: View a lamp and see the related bulb. If I view the Bulb I can see the related products. 

It must be a many to many relationship. A Lamp can have many related parts and each part can relate to many different lamps.

Thanks in advance?