List of Cities for UK in Lookup, please?

[Ani]

Hi Guys
I have posted this in General because I dont actually know where I should look or ask about this. I have created a form for CustomerDetails via a query.
As the entries such as Area, Town/City will be repeating data I believe I should have a lookup on the query.
Do I have to manually enter the different cities for the lookup or is there a way to do it automatically?
Please excuse me if this is an obvious answer, I dont want to copy and paste from some sort of list to then find it shouldnt have been done.
Are there rules about copying a list of cities etc into a Lookup as regards format etc?
Thank You
Ani

 

[Lightwave]

Copied from wikipedia makes for interesting reading. There is a British Standard...
And yes you will probably have to type in the cities yourself although you can probably find a list somewhere which you would be able to copy and paste into the right table. Saying that a lookup on things like the city for the address query might be a nice thing but could be left till later. I tend to focus on that kind of thing at the end.

You should have a field for each new line below.

I wouldn't worry too much about Postal Towns I just use towns as a proxy I think the majority of people wouldn't know the distinction between a postal town and their town and the Royal Mail has never really indicated that its a major problem. The important fields I would say are house name / house number / street / town and postcode - and you better have locality in there as well.

Minimum format
Addressee's Name
Number + Street Name
(Locality)
POST TOWN
POSTCODE

Rural areas Addressee's Name
Property Name
(Street Name)
Locality
POST TOWN
POSTCODE

This is the format preferred by Royal Mail. The locality is required only where its absence would be ambiguous. Post towns rarely correspond to political boundaries and often group places that for all other purposes are quite separate. The Royal Mail asks that postal towns be written in block capitals, but in practice they rarely are. Sometimes the postal county is included after the post town, often because of software which requires a county to be included as part of a postal address, even where a county was never required by Royal Mail (so called special post towns).

Additionally, many people in the UK either prefer to use an older format of their address, include unnecessary information, or simply don't know what the correct format is. An address such as 1, Linclare Place, ST NEOTS, PE19 7AG might typically be written as 1, Linclare Place, Eaton Ford (locality), St Neots, Huntingdon (district), Cambs. (County) PE19 7AG.

 

[Ani]

Oh crap! Good job I asked, I forgot that I needed the option for rural address. As most of my customers will be in rural areas I shouldnt have forgotten!
I do understand the difference between Postal Town and Town but only because it is irksome to me! I think even the RM are confused about our address!
I really do not want to spend hours typing Town names into a lookup box! Would I be breaking db rules to do it each time I have a customer from a different town?
Ani

 

[Lightwave]

No ................

 

[Ani]

Thanks. I dont have many customers right now and most are local, so it shouldnt be a problem!
Ani