e-commerce database issue

N

Nitin

hello,

not sure if this is the correct place to ask this but i'm stuck and
need assistance.

I've had an e-commerce website built for my business. it's database
driven and built using asp.

currently the database will not let me have the same category in two
different departments, for example 'Jackets' in both MEN and WOMEN.

i've got the database open in ms
access and can only see 5 tables.

-->tblArticle
PK id autonumber
Pdetailid number
ArticleColour text
Articlesize text
ArticleDesc text

-->tblHome
txtHome memo

-->tblMasterCategory
PK id number
Title text

-->tblProductDetails
PK id autonumber
Catid number
Pdtid number
PdtTitle text
PdtPrice currency
PdtDesc memo
PdtCode text

-->tblProducts
PK id autonumber
Catid number
SubCategory text
SubCatorder number

the site has different departments.. MEN, WOMEN, ACCESSORIES..etc..

the database is manipulated via the backend admin panel. the process
goes as follows,

1,select department (Men)
2,click create new subcategory
3,enter Title (jackets) and display Order
4,hit Submit

--repeat process for Women department---

but no success, not even an error msg (bad designing i guess)..

so now i'm stuck.

database and website technologies have changed somewhat since i was at
University so i'm a little rusty.

does any of this help?

Thank you
 
A

Armen Stein

currently the database will not let me have the same category in two
different departments, for example 'Jackets' in both MEN and WOMEN.

i've got the database open in ms
access and can only see 5 tables.

-->tblArticle
PK id autonumber
Pdetailid number
ArticleColour text
Articlesize text
ArticleDesc text

-->tblHome
txtHome memo

-->tblMasterCategory
PK id number
Title text

-->tblProductDetails
PK id autonumber
Catid number
Pdtid number
PdtTitle text
PdtPrice currency
PdtDesc memo
PdtCode text

-->tblProducts
PK id autonumber
Catid number
SubCategory text
SubCatorder number

the site has different departments.. MEN, WOMEN, ACCESSORIES..etc..

the database is manipulated via the backend admin panel. the process
goes as follows,

1,select department (Men)
2,click create new subcategory
3,enter Title (jackets) and display Order
4,hit Submit

--repeat process for Women department---

but no success, not even an error msg (bad designing i guess)..
Click to expand...

Overall, the table design in this structure is not very clear. I
don't see an obvious reference to "Department" - maybe that's
tblMasterCategory, containing "MEN". And maybe tlbProducts contains
the Category as a SubCategory, containing "Jackets".

If so... there is probably a unique Index on CatID and SubCategory in
tblProducts, which would prevent the duplicates. You might try making
that Index non-unique. Be aware that there might be come other
programming that needs that combination to be unique. You'll just
have to test it out and see.

If that doesn't work, can you just name your categories uniquely, like
"Men's Jackets"?

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
N

Nitin

Overall, the table design in this structure is not very clear. I
don't see an obvious reference to "Department" - maybe that's
tblMasterCategory, containing "MEN". And maybe tlbProducts contains
the Category as a SubCategory, containing "Jackets".

If so... there is probably a unique Index on CatID and SubCategory in
tblProducts, which would prevent the duplicates. You might try making
that Index non-unique. Be aware that there might be come other
programming that needs that combination to be unique. You'll just
have to test it out and see.

If that doesn't work, can you just name your categories uniquely, like
"Men's Jackets"?

Armen Stein
Microsoft Access MVPwww.JStreetTech.com
Click to expand...

hello,

i'm not all that clear on how they're related either. looking at the
tables in relationship view, i don't see any connections..?!

i am currently uniquely naming the categories, it's just that if the
customer has entered the MEN department he/she would already be aware
that the jackets were for men. i guess i'm just being picky...

thanks for your input :)
 
Top