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

[AJITnayak]

I have a 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 comboboxes, Manufacture and Model No.

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

When a particular manufacture is selected for example Manufacture 2 -> The Model No combobox should display only MAD-01 and MAD 02.

Based on both selections a text box must be loaded with length, width, height.

I tried sample code and assign the combobox with database values. I got duplicate values like this:

Manufacture 1
Manufacture 1
Manufacture 1
Manufacture 2
Manufacture 2
Manufacture 3
Manufacture 4

How can I do this correctly?

I have attached database in pdf file & attached the combobox form here.

Solar_Panel.pdfSolar_Panel.pdf