Hello All,

I need to implement a many to many relation ship between two tables.
One table contains a material used to create products and the other contains
products that we sell. A product can have a number of different materials
used in it and a material can be used for a number of products.
In the past, I've seen schemes where the materials would have a comma delimited
field and the product table would get the different number of materials associated
with it by doing a join on this field and using the IN statement instead
of the equal sign. I was wondering if there was a better way of implemeting
this.

Thanks in advance.