So i'm trying to come up with the best method to create a "Size" table for rugs.....there are only 7 options that any particular sized rug must be categorized in and the value of one of the 7 options needs to be returned. What would be the best way to create this lookup table with so many different variations on length x width of the actual size of the rugs???
2x3 2x4 2x8 5x7 8x10 10x13 12x15 these are the only options.....I have a size field format is that has all the sizes of the rugs in the following format WxL
2'6" x 10'0", 8'0" x 10'0", 7'6" x 10'0", 2'6" x 12'0", 2'6" x 3'10", etc Also have a Width field that lists the following format 5' 9", 11' 5", 1' 6", etc and there is also a Length field.
What would the best approach to building a table with so many variations, but only 7 options to categorize in?
2x3 2x4 2x8 5x7 8x10 10x13 12x15 these are the only options.....I have a size field format is that has all the sizes of the rugs in the following format WxL
2'6" x 10'0", 8'0" x 10'0", 7'6" x 10'0", 2'6" x 12'0", 2'6" x 3'10", etc Also have a Width field that lists the following format 5' 9", 11' 5", 1' 6", etc and there is also a Length field.
What would the best approach to building a table with so many variations, but only 7 options to categorize in?