I created a table with a “lookup” field that gets its value from another table. That works fine.
Now, when I create a query on that field, I need to enter the data into the query directly. The problem is that I do not always remember the exact spelling or name I am looking for. I would like to have a pop-up list appears that I could use to pick the data from. I know I can use something like [enter name] in the query box, but that is not what I want. I want a pop-up list like the one that appears when I manually add data to the field.
First, I hope I explained this correctly, and two, is it possible?
Thanks!