Update page losing original values when submitted?

Good afternoon, an update page was created by DA wizard, I tyen edited this to allow update of 2 tables as required, manually inserting a 2nd update table.

I have a problem now & cannot work it out despite spending several days on it! Some of the original values do not pull through to the update form, hence when resubmitted it add a zero to the value of these columns?

For example, I have 2 select boxes on my update form. The backend table has the correct values but when update form is opened the values are set to the select box title and not the actual value?

Secondly the update record created by DA doesnt insert update into the 1st update record [contacts] although it did when first created. Running both inserts individually also works, I have attached the page if anyone can see my errors?

Thanks

for the select lists, click the dynamic button in the property selector.

in the Select Value equal to section, you have selected the name columns:
CaseStatusName
CaseTypeName

from the WADAtblcontacts recordset, you need to select the ID columns instead.


for the contacts update issue, you need to edit the recordset so that the contactID value is returned.

add another hidden element to the page and set the initial value to use the contactID.

in the Contacts update behavior, click the lightning bolt next to the Key Column value and select the new hidden element.

Hi Jason, thanks for the tips. Regarding the menu lists, that worked great.

However inserting the hidden ContactID field and applying value to key column now seems to have another strange effect. Once update it does change record but removes the value from 'refrerrelname' column which is unrelated. Its odd as though that column is referenced in the recordset I didn't include in the update page itself as no requirement.

On the hidden field I am dragging the binding of ContactID across to the value like:

<input name="ContactID" type="hidden" value=<?php echo $row_WADAtblcontacts['ContactID']; ?> />

Is that correct? I also tried just using 'ContactID' but that didnt update the record.

Hi Jason, please ignore my last post, I just applied same logic as you suggested for the 1st issue with drop downs and it worked a treat.

Thanks again.

Gary