splitting field data

[lez]

Hi Guys,

I am looking for help spliting field values into multipe tables. Let me
explain,

I have a table with field 'style' this contains sizes, colours etc. Each
'style' needs to be put into a table of there own. and then need to relate
the productID with each of these styles

each style value is a constant format eg
Colours:Red /
Size: Small /

So the the style is always xxx:
and the value is ended by /

I will need to group by style with the colours within that group.

Also I would have to create an ID in the table I am spliting this data from
so can retain the link to the product.

All suggestions welcome

Many thanks
Lez

 

[KARL DEWEY]

Post a couple of sample records as your explaination doesn't quite make it.

Why do you think that you need a separate table for each style. Just have a
field named Style in ONE table to identify the style.

 

[John W. Vinson]

Hi Guys,

I am looking for help spliting field values into multipe tables. Let me
explain,

I have a table with field 'style' this contains sizes, colours etc. Each
'style' needs to be put into a table of there own. and then need to relate
the productID with each of these styles

each style value is a constant format eg
Colours:Red /
Size: Small /

So the the style is always xxx:
and the value is ended by /

I will need to group by style with the colours within that group.

Also I would have to create an ID in the table I am spliting this data from
so can retain the link to the product.

All suggestions welcome

Many thanks
Lez

WHOA!!!

No, you most emphatically do NOT want a different table for each style.
Storing data in tablenames is *never* a good idea.

Please explain the actual structure and contents of your current table -
fieldnames, datatypes, and so on.

I can see wanting a table of Colours and a table of Sizes and so on... is that
what you mean?

 

[lez]

Hi John/Karl,

Yes a table for colours and a table for sizes and one more for 'other'

Basicly the products can have a varient or either size, colour or other. the
data has come to me in a spreadsheet which I have imported into access

each product has a parentID (productID) and each variant has a childID
(itemID)

So I assume for each 'style' varient I have (3), I want to store the varient
value in that table, red, green, blue. Small, Medium, Large etc.

The data structure of the current table is
productID : number
itemID : text
product : text
style: text
price1 :number
price 2 : number
brand2 : text

Sample of Data Below:

productID
itemID
product
style
price1
price2
brand2

2496
SCT6615
100N Foam Lifejacket - Typhoon
Colours: Red / Size: Childs /
24.99
24.99
Typhoon

2496
SCT6618
100N Foam Lifejacket - Typhoon
Colours: Red / Size: Toddler /
24.99
24.99
Typhoon

2496
SCT6617
100N Foam Lifejacket - Typhoon
Size: Large / Colours: Red /
34.99
34.99
Typhoon

2496
SCT6616
100N Foam Lifejacket - Typhoon
Colours: Red / Size: Infant /
24.99
24.99
Typhoon

2496
SCT6613
100N Foam Lifejacket - Typhoon
Size: Medium / Colours: Red /
34.99
34.99
Typhoon

2496
SCT6612
100N Foam Lifejacket - Typhoon
Colours: Red / Size: Small /
34.99
34.99
Typhoon

2496
SCT6614
100N Foam Lifejacket - Typhoon
Size: XL / Colours: Red /
34.99
34.99
Typhoon




Regards
Lez