Search results

Hi, i am developing a clothing order management database. I have so far got [order details], [products], [product details] entities. This is so that products with the same model code can have a selection of colours and sizes which are held in the product details table. I followed this...

With regards to the sub tables. I have another post running with a similar question. e.g. colour sub table: There are about 10 unique colours for each model and there are possibly over 100 different models. If i have a subtable for colours, how will i ensure that for one model i can only...

So you think i should do it by literally having a list of products hundreds long. i.e. [ProductUniqueID] [ModelNo] [Catergory] [Description] [Colour] [Size] [1] [0161] [Polo] [Classic Polo] [Black] [Small] [2] [0161] [Polo] [Classic Polo] [Black] [Medium] [3] [0161] [Polo] [Classic Polo]...

I dont a colour palatte i need to enter in my own text colour values. any ideas?

Hi. I want to select a product then be able to select a colour from a list that relates to it. I want the colour lists to be different for every product. (clothes) Whats the best way to do it? Thanks Jonny

ok, you mentioned its best to mdel each product size individually. However, with our products, it would mean having to repeat a product description, colour code, colour description etc etc approx. 5x (Small, Medium, Large, XL, XXL) Surely there is a way to have one row with all the product...

Thats helpful, thank you. Just a thought though. There are only 5 different size scales in total, i.e. outawear, jeans, shirts, shorts, tees. Should i create a seperate table with these size scales then link cascading ocmbo boxes. I could reference them A-E, then when a user selects a...

Hi, I am trying to design and build an orders management database for a clothing wholesaler. Has anyone got any ideas on what entities i should have. I thought: Clients (Customer Details) Orders (Inc. order date, ship via etc) Order Details (sizes, quantity of orders per size) Product...