Search results

  1. J

    Product sizes and differing prices

    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...
  2. J

    Help with clothing order management database

    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...
  3. J

    Help with clothing order management database

    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]...
  4. J

    Relate list of colours to unique product id

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

    Relate list of colours to unique product id

    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
  6. J

    Help with clothing order management database

    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...
  7. J

    Help with clothing order management database

    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...
  8. J

    Help with clothing order management database

    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...
Back
Top Bottom