#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Location
    Delhi
    Posts
    41
    Rep Power
    5

    How to remove Duplicate Combobox & Load the value into Text box


    Dear all,

    I have database like this

    Manufacture Model No Length Width height

    Manufacture 1 MD-01 200 300 100

    Manufacture 1 MD-02 300 400 100

    Manufacture 1 MD-03 400 300 150

    Manufacture 2 MAD-01 200 450 100

    Manufacture 2 MAD-02 250 400 100

    Manufacture 3 MDI-01 300 300 100

    Manufacture 4 MOv-01 350 300 100

    I would like to create 2 combobox -

    1) Manufacture 2 ) model No

    Manufacture should display for above example Manufacture 1,Manufacture 2,Manufacture 3, Manufacture 4

    when particular manufacture selected for example Manufacture 2 -> combox should display only MAD-01 & MAD 02.

    Based on both selection text box must me loaded with length, width , height.

    i tried sample code & try to assign the combox with database value. I found duplicate list of column. Like for combobox1 accumulate

    Manufacture 1

    Manufacture 1

    Manufacture 1

    Manufacture 2

    Manufacture 2

    Manufacture 3

    Manufacture 4


    Is there any example program available to do this. How can do this.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2002
    Location
    Stevens Point, Wisconsin
    Posts
    623
    Rep Power
    19
    this is a hairy situation. Ideally your db should be normalized where manufacturers are in a lookup table and exist only once, and the ManufacturerID is present in that table and the Model (or better yet, named Product) table as well. This will make future queries quicker and easier to write.

    Do you have time to redo your db?

IMN logo majestic logo threadwatch logo seochat tools logo