Yes, yes everything is right :) but under left click I'm not getting a drop down list and under right click I'm not getting the same options as in the original Category field (no edit list, only equals and so on)
Everything is as you say. I even tried doing a direct copy (copy/paste instead of manually rewriting) and replacing one of the existing tables and still have the same problem.
OK, I must be really really stupid. I did everything you said. Added the new category to my contacts view, and when I click on it I get the down arrow as for a drop down list but no list :/ Despite having every setting exactly the same as the original Category filed.
Also there 'Edit List...
First of all hello to all of you! :)
I am so sorry to waste your time with something so basic but I have never ever used access in my life. :o
So, using the Access 2007 Contact Database template I want to create a database of contacts, obviously ;)
This template has a Column called 'Category'...