TheNiceGuy
New member
now, i have some comboboxes, i want to insert a record to my database, wherein it will search the database from the value inside the combobox, then the record will add beside it...
for example,
(remember the comboboxes are fixed, and you will only input texts to the textbox and it will be recorded in the database triggered by a button)
Company Name(combobox - for instance, i selected "Dell")
Product (combobox - i selected "Laptops")
Product Model (combobox - i selected "Inspiron")
Enter your Product code: (Textbox - i put "GT911")
after i entered a value from the textbox and clicked the button, how can it be done like this?
CompanyName----Product------ProductModel---- ProductCode(these line are fields)
Dell--------------------Laptop--------inspiron-------------GT911 (it must be located here)
Dell--------------------Desktop------XPS
Dell---------------------Printer-------Canon
how can i code these in sql statement?? i want the code to search the fields from the comboboxes and put the value of the textbox exactly where the comboboxes are lined..
please help me.. ill give 10 points for the best answer.. needed asap..
for example,
(remember the comboboxes are fixed, and you will only input texts to the textbox and it will be recorded in the database triggered by a button)
Company Name(combobox - for instance, i selected "Dell")
Product (combobox - i selected "Laptops")
Product Model (combobox - i selected "Inspiron")
Enter your Product code: (Textbox - i put "GT911")
after i entered a value from the textbox and clicked the button, how can it be done like this?
CompanyName----Product------ProductModel---- ProductCode(these line are fields)
Dell--------------------Laptop--------inspiron-------------GT911 (it must be located here)
Dell--------------------Desktop------XPS
Dell---------------------Printer-------Canon
how can i code these in sql statement?? i want the code to search the fields from the comboboxes and put the value of the textbox exactly where the comboboxes are lined..
please help me.. ill give 10 points for the best answer.. needed asap..