Hi

I'm hoping someone will be able to point me in the right direction.

I have a details view which pull information out of an sql database which a user can then update. All this is working fine, however now comes the bit I'm having difficulty with. Within the details view is a drop down list with a list of team names. Through a separate gridview a user can either update these team names or if the team is no longer part of the company it can be made in-active. If it has been made inactive that team is removed as an option from the drop down list.

Now what happens is if the team name has been made inactive and a user tries to edit a record via the details view with that team name associated with it I get the error TeamNameDropDownList has a SelectedValue which is invalid because it does not exist in the list of items. I understand why I'm getting this error, because the team name is no longer in the list of options but how do I get around it? I'm thinking of maybe some sort of if statement but not sure where to start?

Any help would be mucho appreciated

Thanks

well.. I can see a little flaw in your logic (IMHO), why can you inactive a team name that has related records active??

I thinking 2 solutions, one is to avoid putting inactive something that should be active (or that records are something like orphans??) the second is to move the childs records to another team.

what happends if I want to change the other info of the record (not the team name), but the team name is inactive???

I think that you have another kind of problem here...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Dear RubyRue,
Try to bind the details view and the drop down list in the details view when ever you update a record in the gridview of the teams.

I hope this would help you.

Asmaa,