codes and descriptions

[Lyndseyd]

Hi i have designed a database where the users use a combo box to find a particular code they want..for example dog_brown or dog_grey, on the report which i have produced this code for the type of dog shows up to. I have another table which has a column with the code and also the description...eg dog_brown...brown dog. My users have asked me if on the report which i have produced can the description be shown instead of the code. I dont know if this can be done...any help would be grateful. Thanx

 

[neileg]

BAse the report on a query. Add your main table to the query and your code table. Join the two tables on the code field. Add the description to the query and it will be available for your report instead of the code (or as well if you want them both).

 

[Lyndseyd]

Thank you very much

 

[stepone]

My users have asked me if on the report which i have produced can the description be shown instead of the code

Hi there. It might be simpler, if the report is already written, to change the text box where you are currently displaying the code, to a combo box. This can be set up just like a combo box on a form, with 2 columns (first column hidden) so that it displays the description, rather than the code.

StepOne