Catalog System - Design

[SAY1]

We are facing an issue in designing a particular solution in Microsoft commerce server2002 Catalgos module.

Each product can be under the combination of any of the following category
1.Brand
2.Type
3.Pack

The relation between the product and the categories are

product to brand is 1:1
product to Type is 1:M
product to Pack is 1:M

Product A belongs to { Brand A , Product Type A and pack Type A }
Product B belongs to { Brand A , Product Type (A&B) and pack Type A }
Product c belongs to { Brand B , Product Type (A&B) and pack Type A }

I am having two solution in designing the follwing Requirements in Commerce server

Ist Solution :

By keeping the Brand(A,B,C) , Product Type(A,B,C) and Packtype(A,B,C) as category

and assign the product to the respective categories.

Limitation that i am facing:

If i am searching via Product type i am not able to identify which Brand or Pack type a product belongs to. Here i have to explicitly search from the search

option available from the

2nd Solution :

By keeping Product Type and Packtype as properties (Multiple choice option) in Product Definition and assigning the product to the Brand(A,B,C)

category;

Limitation that i am facing:

For Business user this is hard for him to search He needs to give explicitly give the corresponding "Brand","Product Type" and "Packtype" to find the

particular product.


Please Suggest me a solution which will help me in displaying all Brands,Product Type,PackTypes and its Product details in Bizdesk and in Site.
How can i over come the Difficulty.