My formview is having an issue. I have two dropdown boxes. Facility and Department. The department list is dependent facility. So I call the facility and then then pull the department where facility is equal to what is in that first dropdown. For example.. First dropdown box is Microsoft and the dropdown list all the departments. Then I using SelectedValue = (Bind etc etc) to get the specific Facility (Microsoft) and department that is associated with the formview record.
This all works fine.
Now the issue. If the user wants to edit that facility or department, it does not work. I get an error on the Bind. Because when I change the facility, the department list needs to change and the Bind is no longer valid.
So how do I get the field to unbind from the formview when the facility is changed?
If it is not possible, suggestions on how make this form user friendly.
This form is create by a user. When they submit it, another user gets the email. That user logs in and looks at the original submission and they may need to make changes like directly informaton to a differnt department.