AnsweredAssumed Answered

Help With Data Structure

Question asked by cmdunn1 on Apr 17, 2009
Latest reply on Apr 17, 2009 by cmdunn1

Title

Help With Data Structure

Post

I am fairly new to FM and need a little help setting up a data structure. I need to have put products into multiple categories. The place where I am stumped is the categories have to be broken down like this:

Product Line : Category : Subcategory

Products will then be assigned to the subcategory but the problem is each product could be in different subcategories in another product line. For example:

Brand A : Category 1 : Subcategory 1 : Product 1
Brand B : Category 1 : Subcategory 1 : Product 1

OR

Brand A : Category 1 : Subcategory 1 : Product 1
Brand A : Category 4 : Subcategory 3 : Product 1

Any suggestions will be greatly appreciated!







Outcomes