How to view descriptive codes in a multiselect field

[PolarBear]

I have a field that contains multiselect code data.
For example, the code field may contain the following 01,05,07
Each 2 number code is has an associated description.

If I run a query and link the code field to a table that contains the a Code field and description on each row, is it possible to have the query return the descriptive names for the items in the multiselect field.

Not sure if I described this very clearly. Of course it is easy to link to a Lookup table and display a code description when ther is only a single code in the field. Is it possible to desplay descriptions using a lookup table when the field contains multiple selections (codes)?

Regards,
Polar Bear

 

[Pat Hartman]

When you have a one-to-many relationship, the many-side data need to be stored in a separate table. You absolutely should not mush them together into a single column. It violates first normal form (which of course is simply a rule) but in practical terms, it simply makes working with the data very difficult.