akalinowski
IS-IT--Management
dont know what this is called so i'll try to explain as best i can...
i have a table that looks like this (lest call this table quantities)
STYLE, COLOR,SIZE_RANGE, S1, S2, ....,S18
so S1 - S18 = size "buckets"
the data will look like this:
TEESHIRT1, BLACK, 032, 0, 2, 3, 5, 0,...
the SIZE_RANGE is a code that refereances another table
that looks like this (lets call it SIZES)
SIZE_RANGE, S1, S2, ...S18
and the data in SIZES table would look like this:
032, , S, M, L, , ....
note that some are blank, these are unused size buckets and should return nothing on a report like they do not exist, these are inactive size buckets.
i want to return the following data
TEESHIRT1, BLACK, S, 2
TEESHIRT1, BLACK, M, 3
TEESHIRT1, BLACK, L, 5
what is the best way to do this?
akalinowski
i have a table that looks like this (lest call this table quantities)
STYLE, COLOR,SIZE_RANGE, S1, S2, ....,S18
so S1 - S18 = size "buckets"
the data will look like this:
TEESHIRT1, BLACK, 032, 0, 2, 3, 5, 0,...
the SIZE_RANGE is a code that refereances another table
that looks like this (lets call it SIZES)
SIZE_RANGE, S1, S2, ...S18
and the data in SIZES table would look like this:
032, , S, M, L, , ....
note that some are blank, these are unused size buckets and should return nothing on a report like they do not exist, these are inactive size buckets.
i want to return the following data
TEESHIRT1, BLACK, S, 2
TEESHIRT1, BLACK, M, 3
TEESHIRT1, BLACK, L, 5
what is the best way to do this?
akalinowski