Preselected values in drop-down lists

[Guest]

Hi everyone,

Some quick background before stating the issue: I've developed a set of forms in ASP.NET working with a SQL Server 2000 db where my client can add, edit, and search records within their intranet. When adding a record, they are making some selections from a drop-down list where the values are dynamically populated from a lookup table. There are three sections to the form and each section gets its values from a different table. When editing a record, the drop-down lists should show all the choices but prepopulate the list with their earlier selection.

Here's the issue: everything is working just fine on my box and is working 90% on my client's server. The problem is that when editing a record, two of the three sections of the form are showing the correct values. The third section is showing the first choice in the drop-down list rather than what was recorded in the db.

Again, this is not happening in my development environment. It's only happening on my client's environment. I've triple-checked the code and confirmed that the datatypes in their tables match what I've got set up in my db. The fact that these pages are behind my client's firewall make the usual trial and error kind of troubleshooting very difficult.

This is very mysterious. Any suggestions for what I can check and how I can troubleshoot this?

Thanks.

[Guest · Accepted solution]

In case anyone else comes across this problem, it seems that deleting and recreating the table solved the problem. I renamed the original table and compared it to the one I recreated and they appear to be identical but nevertheless that was the solution.