135
builderb,
Either you can add the same listing twice under different categories. This will cause redundancy in the first place and if you don't want the user to have the burden of this (like editing all listings in case of a change), you will need to do a lot of programming as well.
However, I can imagine that in some cases also the text in a listing would be different for each category, to give a better description of the company's services matching the category. In those cases it would be essential to have two different listings for the same company.
The cross table would be a much nicer solution if a customer just want to have the same listing in multiple categories, like you mentioned, but in that case you will need to edit all your queries. However, once you have done that you will have a great new feature
.
If you build in the cross link table, you will have both options available to the customer, he can assign multiple categories to one listing or, if he wants, he can still make the double posting.
Regards,
Martijn