Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: value in the dropdown list

    I have a drop down list, there are four choice, pending, approved, denied, cancel. But now the user want to change pending to "pending/renew", but i still want to store the value as pending. How can i do this. Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    That is one reason why I am a fan of look up tables. What I would do is create a table called tblReason (or whatever is appropriate for the name). With the following schema:

    ReasonID Reason
    1 Pending
    2 Approved


    The ReasonID is set to an Autonumber field and when I store the value that the user selected I store the ReasonID and not the Reason. That way the Reason can change several times and it won't effect the data.

    For your combo box you will need to make it have two columns with the width of the first column (ReasonID) 0". That way the user just sees the Reason and not the ReasonID.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •