Is there a way to have the display value for a multivalue field show on a report instead if the underlying ID
Is there a way to have the display value for a multivalue field show on a report instead if the underlying ID
Yes, although there are problems with it. See point five in this VERY IMPORTANT LINK in http://access.mvps.org/access/lookupfields.htm