Question Grouping items in Access 2003 (1 Viewer)

[RobBhat]

Hi All

I need help with allocating a value for a group of products

I have products A1, A2, A3 , A4, A5,A6, A7. A8, A9, A10, B1, B2, B3, B4, B5, B6, B7 etc.

A1 to A6 have a category Bags
A7 to A10 have a category Sacks
B1 to B3 category Rolls
B4 to B7 category sheets

Instead of listing each product in the table, I wanted to find a way to group the products whereby I have only the prefix of the product in the table (A,B,C) etc and have a way to allocate the category according to the suffix (1, 2, 3, 4, 5) as described above.

How can I do this please? Can anyone help me with a solution?

Thanks

 

[The_Doc_Man]

This is the Excel way of thinking. In access, you have a category field to go with the product ID field. Then you can associate ANY product code with ANY category as you choose. Your method would lock you into a corner the first time you have a new item in category Bags. My method? No problem. Just mark the product's category in its record and you have your fixed association.

I might add that trying to encode category into a product code but not having a separate product code field means you are forever going to have to deconvolute the product code to decide what it really is. If you have a Category field, no questions remain.