Hi

I have a windows form with a combobox and listbox.
I have a table name Categories with two columns Category and Subcategory.

Sample data

Category SubCategory

Breakfast Eggmuffin
Breakfast Sausage Muffin
Sandwich Hamburger
Sandwich Cheeseburger

I would like to display the Category in the combobox avoiding the duplicate rows.
Based on the selection of the Category in the combobox, i would like to display the subcategory column in the list box.

It would be nice if anyone could help me with this.

Thanks
Sathi

Hello..

Let's take aside that the table is bad constructed (Categories should be on another table, and this table should had only the id), You could solve your problem using a SELECT DISTINCT category FROM ...

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

Hi

Now I have two tables

1)
Categories

CategoryID --- PK
Category Name

2)
Subcategories

CategoryId----FK
SubCategory

I would like to display the category name from Categories table in combobox.
Based on the selection from the combobox corresponding subcategory from the Subcategories table( here Category id can be duplicate)in the listbox.



Would be nice if anyone could help me in this.

akssmv:
Re-structure the Sub-Category Object to the following:

SUBCATEGORY_TBL
SUBCATID PK number,
CATEGORYID FK number, /* Comment: Enforce FK Referential Constraint */
SUBCAT_NAME varchar (80)
Also include for Delete operation, to include Cascade Deletes.

Then use the table in you listbox with the following Query:
select DISTINCT a.CATEGORY_NAME, b.SUBCAT_NAME
from CATEGORY_TBL a, SUBCATEGORY_TBL b
where a.CATEGORYID = b.CATEGORYID
orderby b.CATEGORYID, b.SUBCATID
groupby b.CATEGORYID, b.SUBCATID

Hope this helps.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

i will try it and let you know, thanks