I have a ddl that displays cities for the user to select.
2 St. John's
If the user selects St. John's (ID =2), the ID 2 gets wrote to the database for that user..this is fine, however when the user comes back to the page and changes some other data and NOT the city, St. John's gets ID=1 in the ddl, so when the user writes to the database again, the city changes to Toronto (ID=1)...
HOW DO I GET AROUND THIS. I am programming in VB
.NET and using a Access database. i have also assign the value in dropdown list in page load event
Please any help is greatly appricated.