1 Product in Multiple Categories

Hi All,

I currently have a database with a Products table and a Category table.  In the products table i have a field that holds the category id from the category table.  Only problem is that you can only select one category for each product.  If the product needs to be in multiple categories i need to copy the product into a new record for the other category.  Can someone guide me on how i can make this simpler, so i only have to add the product once and have it for several categories?  Would it be best to add a few extra fields to the Products table for the extra cateogries?

Thanks,
Beau
...