"n" levels of Atrributes for Product Coding convention, so .....
I'm new to Access and not sure if Access is the tool, given the
relational nature. Anyway, here's what I need to do.
Classify our products, all 18,544 of them. They fall in 11 major
categories, up to 34 subcategories for each major category, each
subcategory can have up to 25 columns with up to 90+ fields per
column, and so forth, for 8 distinct fields to describe a single
product and derive an associated unique identifying character string
(part number).
The challenge is to use comboboxes to classify each item. New items
are added frequently, as well as some are dropped, resulting in about
500 new items per year.
The need arises from inconsistency in naming/description of each item.
Over time it gets ugly. No two people do it the same way.
Right now it looks like just over 150 tables with a minimum of 6
columns and up to 63 columns with a maximum of 90+ fields, except one
table which has 3 columns with 301 fields.
The column heading describes the applicable attributes, while table
name describles the hierarchial placement, hence cascading
synchronized comboboxes.
Each combobox will have 2 columns, the 1st column will contain a
character and the 2nd column will contain a word or phrase. I need to
somehow relate/identify these 2 columns to the selection made from the
preceeding combobox selection which may or may not be in the same
table. Hyperlinking is the general idea. The selected field sends me
to the the correct table and the appropriate columns.
The form(s) for assigning this product classification consist of:
------------------------------------------------------------------------------------------------
txtItemNo from tblItem - unique number generally referenced
txtItemDescription from tblItem - noun description not unique
The 2 generated text boxes will have the follwing information :
1.) txtbox_1 is a full description field with the concatenated
words/characters from at least 6 of the 8 fields using the 8
sequential comboboxes. 2nd column in combobox
2.) txtbox_2 is for 8 characters concatenated from all 8 fields using
the 8 sequential comboboxes. 1st column in combobox
-------------------------------------------------------------------------------------------------------------
While I'm asking for the moon, how do I get the column 1 values to go
to txtbox_1 and the column 2 values to go to txtbox_2
=[cboCategoryView] & ", " & [cboCategorySection] & ", " &
[cboSectionID] & ", " & [cboProduct] & ", " & [cboProductID] & " X " &
[cboProductAttribute]& ", " & [cboStatus] & ", " & [cboMarkup]
-------------------------------------------------------------------------------------------------------------
I'm sure I've left something out ..........
Like queries, lack of primary keys and so on.
Thanks
dekker
