Hello,
I keep having problems in “forms” where I want to display the description of a code and not the code itself to the user, example: Frequency code is “W”, description is “Weekly” so on the form I want to display “Weekly” instead of the code “W”.
The form has a feature to use “Display” type fields, use a query to “select” a value from a drop-down box with a list of valid values.
My query is this:
Select description from codes_table;
The problem is that this query displays anything on the codes table and does not display the description using the code on the actual record on the db.
Now If I change the query to match to the record on the database with this:
Select description from codes_table where code = {freq_code}
The problem with this query is that it restricts itself to the matching value and I can not update the field, the drop down box only displays one field nothing else.
I want to be able to update this field so I need to access the list of fields but I still want the form to show the correct description when it comes up using the “actual value” on the database.
Showing a default is confusing, the user things the value is incorrect and needs to be changed but the database is correct.
How can I fix this, thanks in advance?
Thanks.