Has anyone used multi value fields in a table? This is a new feature in access 2007 and 2010.
I tried it out, but am having issues displaying the value in a form. I see the ID#, but not the common name I'd like to see.
I'm not sure where to change the properties on this. I've looked all over the internet, and really have found no help.
To make sure I explained what I was looking for, I have a tableA, with FacilityId, and Facility, Location, and Building. I set tableB up with a lookup field, which is looking at tableA to pull the facility. When you select the combo box on tableB, it drops down and displays the data from Table A, just like a combo box. You have your list and check boxes. Select the facilities you want to choose for your record, and it displays them, as Fac1, Fac2, Fac3.
I can create a query against tableB and it displays the value the same way Fac1, Fac2, Fac3. When I create a form, however, it shows 1, 2, 3.
I can not find anywhere to change the combo box's properties to show Fac1, Fac2, Fac3, rather than the ID, 1, 2, 3.
Any help is greatly appreciated.
Thank you!!!