i am building a databse and looking for a bette way to construct it..
what i have done is:
Electronics, non Electronics
computers, TVs, Radio
mouse, cable1, cable2
color, size,supplier, warehouse
this is the way i set it up so on my front end if the user choose Electronics(from division menu) the subdivision menu shows only the related item (computers, TVs, Radio), the same when the user select from the subdivision the related items only whows up and same for the details.
everything works fine and pretty good. but some subdivisions has same items like:
computers-------->>> has mouse, cable1, cable2
TVs-------------->>> has cable1, cable2.
so as you see in the items table there are repeating items and this makes a problem when creating a views..
is there any better way to construct this database (keep in mind that all of the menus will be dependent drop down menus - selecting from a table, the submenu only shows the related items and so one..