Hi There,
I need to store multiple manufacturers for a single product and then recall them individually in the Manufacturers search.
For example:
Product XYZ was made by John Smith, Debra Waters, Jane Doe.
I need to be able to assign Product XYZ to all three of them without creating a manufacturer named "John Smith, Debra Waters, Jane Doe" and without duplicating the product 3 times.
THEN
On the store front, when you select John Smith, Product XYZ will appear, same with when you select Debra Waters and Jane Doe.
I figure that I can have the Manufacturers select in the admin side show as a combo box rather than a drop down and store the multiple manufacturers as an array, then plug it into the SQL database upon saving the product, however how would I then call each individual person and Product XYZ on the store front?
is there an easier way of doing this? A module perhaps?
Thanks!
Justyn
Bookmarks