macsgirl 0 Newbie Poster

Edit mode the index of a dropdownlist does not start at the right value.
I am having problem when in edit mode the dropdownlist the index does not
start at the right value. I use Inner Join for my two dropdownlists.

tbl_Users_StoreID
StoreID Store
1 Name1
2 Name2

tbl_Users_AccessLevelD
AccessLevelD AccessLevel
1 Administration
2 Calling Card Manager
3 Cashier

These StoreID, AccessLevelID are in my

tbl_Users table.
UserID
StoreID
AccessID
UserName
FullName

Now suppose for UserID =1
StoredID = 2

But when I am in editmode the Store is starting
at Name1 instead of Name2.
It is saved in the Database as StoredID =2 which corresponds to Name2.
Please help me.