Michael Morin said:
I want to add a county column in a table with address information. I have
a list of towns for each county but I am not sure how to best indicate
which county that town is included in. I have a list of 700 or so
addresses so I don't have time to just type in county info for each
address.
The Royal mail requirement for a County name to be included in (many but not
all) address went some years ago. Counties (as I and many people knew them)
disappeared in 1974 (England & Wales) and 1975 (Scotland). Since then
counties have been created in England and practically the whole of Scotland
and Wales and some have since disappeared (e.g. Avon) and Unitary
Authorities have appeared. If the Royal Mail doesn't require counties
included in the address I would suggest you save yourself the bother. I
think the only exception would be if you don't have a PostCode for a Post
Town name which is duplicated (e.g. Newport) - but finding PostCodes should
be very easy.
If you really have to add counties the only way is to go to the pre 1974
when it was 'stable' as since then there is a mish-mash of old counties, new
names, changed names and changed borders to contend with.
Bill Ridgeway