Thanks a lot Sorry for all the trouble...............

Thanks Sathi

Wow.....what a nice answer...... just because i am not smarter than you....

Thanks Sathi

Sorry for the trouble. Please help me with the code to get the job done as written in prevous message. I would like to get the categoryId of the selected categoryName of combobox from the Categories table so as to compare and display the subcategory in the listbox

Thanks Sathi

I would like to display the CategoryName from Categories table in ComboBox. Based on the selection from the ComboBox display corresponding SubCategory from the SubCategories table (here Category id can be duplicate) in the Listbox.

Thanks Sathi

Please help me with this...... 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.

Thanks Sathi

Hi Thanks for the reply 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.

Thanks Sathi

Hi 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. Is the table constructed good...? Would be nice if anyone could help me in this.

Thanks Sathi

Thanks a lot It was really helpfull

I am new to sql Please help in writing INSERT and UPDATE triggers for five tables, of which 4 has primary key and one has foriegn key Samples would help a lot Thanks Sathi