Hi!
I am designing a simple database as an intern, having no experience with Access beyond my exploration as part of work experience. Well, I have been tasked to create an additional, more complicated database, and if I don't turn something out (even though it wasn't part of my original job), I won't look very good!
I have one problem that I think if I can get it fixed, everything will be peachy. I have looked in several help books and searched on Google, but I think maybe I just don't know what to search for...
The Problem: I am using a multi-column lookup table and have it set to be able to select multiple rows. The drop-down looks like this in my database:
But when I check multiple boxes, it looks like this in the datasheet view:
Is there any way to make it display the information from both columns? I need to be able to search on this information and filter by it.
Or if you have any alternative methods for displaying the information, I'll hear any suggestions!
Thanks!