Regarding listbox and combobox
-
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
-
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
-
AKSSMV wrote:
Is the table constructed good...?
Yes
AKSSMV wrote:
Would be nice if anyone could help me in this.
Help you with what?
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 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
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
-
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
-
AKSSMV wrote:
Please help me with this......
If I can help, I will. However you first need to explain what you need help with.
-
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
-
Ok, but can you stop telling me what you want to do and explain why you can't do it? In other words, what is the problem that you need help with? Which is what I have asked you like 3 times now.
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
-
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
Oh, you don't want to program yourself, you just want someone to create code for you? Do you also need someone to polish your shoes? :)
Luc Pattyn [Forum Guidelines] [My Articles]
Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in
-
Oh, you don't want to program yourself, you just want someone to create code for you? Do you also need someone to polish your shoes? :)
Luc Pattyn [Forum Guidelines] [My Articles]
Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in
-
AKSSMV wrote:
just because i am not smarter than you....
Smarter? Really? That's your excuse? WOW
AKSSMV wrote:
what a nice answer
In four attempts you still have not provided even the smallest amount of information about the programming problem you are having. How long did you think it would be until you irritated someone?
-
AKSSMV wrote:
just because i am not smarter than you....
Smarter? Really? That's your excuse? WOW
AKSSMV wrote:
what a nice answer
In four attempts you still have not provided even the smallest amount of information about the programming problem you are having. How long did you think it would be until you irritated someone?
-
Hi, Your problem is that on the subcategory you need one more field you need Categories ID Category SubCategories ID Category SubCategory You should use the ER Model always that it is possible and that requires a unique identifier per table... for me this is the easiest way to do it!!! Your queries should be some like For the Categories SELECT * FROM Categories For the subcategories SELECT * FROM SubCategories WHERE Category = 'YOUR CATEGORY ID' This way you retrive all the sub categories for that specific Category... with no offense but Sometimes i dont understand what kind of work is this people doing to so this basic questions! i believe that you should buy a book and understant the whole concept about databases before trying to do this kind of job