Hello All,
I have 2 cascading listbox working and since I am working from an already existing database in Oracle, I want the new form that I'm creating to save as the same format as before using another application.
In the first listbox, it has items:
IBM
Sony
Compaq
Dell
In the second listbox the items varies according to the value chosen in the first listbox.
SO, for example if the user choose Sony in the first list and Laptop from the second list. The data should be saved as Sony-Laptop, where the selected values from each listbox is concatenated with a hypen in between and saved to a Oracle table.
How can I achieve this? Should I create another textbox that purely does the concatenation and use that textbox and bound it to the field in Oracle table? Also, when retreiving records, if the data is saved as Sony-Laptop, can I do some coding so that the proper items in the listbox is highlighted?
Thanks in advance!
-Lory

I have 2 cascading listbox working and since I am working from an already existing database in Oracle, I want the new form that I'm creating to save as the same format as before using another application.
In the first listbox, it has items:
IBM
Sony
Compaq
Dell
In the second listbox the items varies according to the value chosen in the first listbox.
SO, for example if the user choose Sony in the first list and Laptop from the second list. The data should be saved as Sony-Laptop, where the selected values from each listbox is concatenated with a hypen in between and saved to a Oracle table.
How can I achieve this? Should I create another textbox that purely does the concatenation and use that textbox and bound it to the field in Oracle table? Also, when retreiving records, if the data is saved as Sony-Laptop, can I do some coding so that the proper items in the listbox is highlighted?
Thanks in advance!
-Lory

