[AccessD] Zip + 4 + foreign phones

Hi 

Gustav and Martin already pointed you to some fairly decent reference works
on the subject
Thanks for http://www.grcdi.nl/ Gustav.

Postal codes:
Learning something from big accounting packages I usually include the
address as one big multiline field, used for address labels and two
additional fields for the two parts of a postal code which (in most cases)
make the code unique for a postal delivery point. You could use this as a
lookup (e.g. for invoices)

In the UK this would be:
postal code, e.g. WC1A 2HQ (for somewhere in London Westminster)
house number: 23
However, they still have the snobbish habit of quoting a building name
instead of the number in the street, in which case you cannot validate on
this.

AFAIK this is the case in most of Europe.

Validation of postal codes, is usually done by including the full tables of
avialable codes (e.g. in student records systems in use at universities),
though you can do something at your ow risk (like Martin did for Canada)
for the UK this would be:
AAnx nAA
A = Alpha
n = digit
x = alpha/digit/nothing


Phone numbers:
Until looking at the above site I was sure that something like
+ccc (r) nnnn NNNNNNN
would do the trick
where:
+  : indicates the number you have to dial for getting international access
(00 in the UK)
ccc : the country code (e.g. 1 for USA/Can or 44 for UK)
(r) : the national access code for interlocal calls (you don't dial this
when calling international or local, only national interlocal)
nnnn: the local area code (e.g. 20 for London or 1392 for Exeter)
NNNNNNN: the local phone number (you only dial this part when calling local)
So 5 fields, where the first could be derived from the country settings of
the machine, and the local area code for the machine should be stored if you
want to use it for dialing (though it doesn't hurt dialing the full
international number, the network understands it, but I am not sure if the
networks billing software thus).
The nnnnNNNNNNNN, actually cannot be more than 10 digits (some
standardisation effort).

The resulting number, e.g. +44(0)1234 123456 is fairly standard (at least in
Europe), even my mobile knows what to do with it.


Hope this is of any help

Cheers

Harry