B
Bill
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?
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?