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.