I am using my own Forms, not the default forms. To call a couple of Select fields I am using like:
<%Dbsql::HTML::generate_select('LOCATION')%>
for the field LOCATION. To add the record it's working fine, BUT, when I try to modify the record the Selected field loose it's value and you have to re-select it. It does not get it's value from the database when the record was added.
How can I get it's value from database while Modifying.
Thanks,
Sara.
<%Dbsql::HTML::generate_select('LOCATION')%>
for the field LOCATION. To add the record it's working fine, BUT, when I try to modify the record the Selected field loose it's value and you have to re-select it. It does not get it's value from the database when the record was added.
How can I get it's value from database while Modifying.
Thanks,
Sara.