Hi,
I have a a databse for a application which is supposed to allow user to raise a support ticket or Question.
The database is already designed and it contains the information regarding the questions/information needed for perticular query.
What I am trying to do is to allow user to come on a page and select the value from first dropdownlist. (This would be the List of Departments like Account, Finance etc)
Based on the Selection of appartment, I want to show another list of values in a dropdown (This would be the Type of queries the each department deals with, for example with accounts, it will be about Status of an Invoice)
So far its easy and I know how I can achieve it but the next part is complicated, I have a table which contains the list of fields for that perticular type of query. For example in above scenario it contains the questions like What is the invoice Number
? On what date it was raised ? etc. (This table also contai ...
Go to the complete details ...