LOV not saving value in select list
626608Jun 2 2008 — edited Jun 4 2008I created a form "created/edit project" via the wizard, and put in the fields from the projects table on the form (via the wizard).
Now I have added a new field to the projects table (CurrencyTypeID), created a foreign key to the "currency types" table, added that field onto the form, and referenced application-level LOV in a select list.
The field shows the data but when I select a value it isn't being saved.
The select looks like this in view source, so you can see that when I select US Dollar the value 1 should save into the projects table.
<select name="p_t38" size="1" id="P19_CURRENCYTYPEID" >
<option value="%null%">- select -</option>
<option value="41">EURO</option>
<option value="1">US Dollar</option>
</select>
What am I doing wrong?
thanks,