so the user(who will place an order) page will look something like this:
Division: please select(drop down menu)
subdivision: please select(drop down menu dependent on Division)
Item: please select(drop down menu dependent on subDivision)
Code: please select(drop down menu dependent on Item)
This structure is working fine with me except one thing.
looking at the Items Table i can see repeated Items like Book, Book, Book, CD, CD, PDF,PDF,PDF) of course every item related to different division and subdivision and has different code but i am sure there is another way to structure this database without repeating the same items. am i right?
so any one can you please help?!?!?
*********** Seems to hard for the people in hear, i ll try to make it easy and hope someone can help:
here is a Data Sample and as you can see it has repeated items.