Hi All,
Im starting a candle company and have 2 tables:
1 table tblCandleSize
Fields:
CandleSize (The full spelling of said size, Small, Medium, etc..)
CandleSizeSku (S for Small, M for Medium, etc..)
1 table tblCandleScent
Fields:
CandleScent (The full spelling of said scent)
CandleScentSku (An abbreviation of said scent)
in my Query qryProductSkus I have it so every combination has a unique combined SKU
The field I created is:
IndividualProductSku: [CandleSizeSku] & "-" & [CandleScentSku] & "-" & "100"
So a small watermelon candle would have a sku of: S-WM-100, example below:
Now what I am trying to do is create another field to add an auto generated number to assign to each Sku. I have watched some videos and read some posts, but have come up empty.
Is this possible and if so, could someone please help.
Very greatfully,
Nick
Im starting a candle company and have 2 tables:
1 table tblCandleSize
Fields:
CandleSize (The full spelling of said size, Small, Medium, etc..)
CandleSizeSku (S for Small, M for Medium, etc..)
1 table tblCandleScent
Fields:
CandleScent (The full spelling of said scent)
CandleScentSku (An abbreviation of said scent)
in my Query qryProductSkus I have it so every combination has a unique combined SKU
The field I created is:
IndividualProductSku: [CandleSizeSku] & "-" & [CandleScentSku] & "-" & "100"
So a small watermelon candle would have a sku of: S-WM-100, example below:
Now what I am trying to do is create another field to add an auto generated number to assign to each Sku. I have watched some videos and read some posts, but have come up empty.
Is this possible and if so, could someone please help.
Very greatfully,
Nick