Unanswered: Creating a lookup query for unique names
I am not hugely experienced with Access so sorry if I am asking a simple question here!
I am creating a table called People. In the table is a field requesting the person's Nationality. I am in the design view of the table and I know under Lookup I can create some kind of query which updates the list box every time a new value is entered into the database. For example you might come to enter your nationality and there be no option for French, so you can enter French into the field without using the list box suggestions. The next time somebody comes to enter a value to this field, French will appear there in the list box. Obviously I only want it to list French once regardless of how many times it appears in the table.
In my books you should consider moving that to another table, afteralkl what is one person French is another persons Français
you need to make sure you users use the same captilaisation ' FRENCH' isnt the same as 'FRENCH'
mind you do you really mean nationality.. or do you mean country of residence. different things altogether..... there are some 240 countries in the world, a full list is farily easily available.
Also be very careful of using lookups in tables. They look like nice handy functionality but have been the cause of corruption. I'm with Mark - simple lookup table. This will also be more efficient. Combo box on the form, not in the table.