Hi Ian,
I did think about that route. The issue is however that I will have hundreds and possibly thousands of products that will change on a weekly basis. Some will be in all major cities and some only in some cities. So, I was looking for a solution whereby when a product was added that multiple cities could be added as well. And not have to then go to the city table and make hundreds of entries for the product. I hope I explained this correctly.
So, I am looking for a way to not only add the cities to the product but also be able search by state for the cities that contain the product as well.