var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: lookup/updating fields
I have a table with fields containing only numeric codes. For example, a field named, "ETHNICITY" contains codes 1=English, 2=Hispanic, 3=Asian, 4=Filipino, etc.
What is the the best way to automatically convert these codes to display only the ethnicity to the end user, such as English, Hispanic, Asian, Filipino, etc.?
If you want to display the etnicity in a textbox, then you can use DLookup() function, or have Join of two tables in your form's datasource.
Another way - is to use combobox to display and update the etnicity. Use combobox wizard, which will help you a lot.