Hi Guys,
Lets say you have the following DB tables:
DB Tables:
tblCompany (Id, Name)
tblDepartment (Id, CompanyId, Name)
tblEmployee (Id, DepartmentId, FirstName, LastName)
Now, lets say you have a ASP form to add an employee:
ASP Form
Company: [DropDownListCompany]
Department: [DropDownListDepartment] (Enabled = False)
Employee Name: [TextBoxEmployeeName] (Enabled = False)
Now, the user must first select the Company, which then allows the fetching of the departments within that specific company and enables the Department dropdownlist.
After the user selects the department, then the textboxes enables.
So the problem is this: The user must select a company, and only then can the application fetch the appropriate departments.
I have found a solution - but it generates a lost of PostBack events. Is there another way?
Thanks in advance
Jeann