DRW DROP down displaying one column but passing the value of another column

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bill (bill.henry3_at_verizon.net)
Date: 09/26/04

  • Next message: Bill: "how to carry over a REQUEST.FORM to a DRW drop down field" 
    Date: Sun, 26 Sep 2004 13:43:28 GMT

    I am doing a Dropdown DRW that queries two columns in a table. I am
    displaying to the user the description of the other column.table, but I am
    storing the ID(pk) of the other column for referential integrity. The
    problem is on the update form, not the new data entry form.
    On the UPDATE form, which is doing a METHOD.POST to a DRW page that runs the
    SQL updates of all the parameters passed in the update page, the parameter
    passed from the METHOD.POST page is the description of my first DRW
    dropdown. The _fk field in which I am storing the referential PK, obviously
    will not accept a VARCHAR description in an INT4 field.

    How do I convert the description back to the referential PK in the update
    form, when passed via a METHOD.POST?

  • Next message: Bill: "how to carry over a REQUEST.FORM to a DRW drop down field"