>Hi everyone...
>
>I am developing a system for a company that exports to many countries, in the UK our addresses usually are formatted like:
>Name
>Addr1
>Addr2
>Town
>County
>Postcode
I don't know whether this is the best way, but you might have a multi-line field (memo, if you use VFP), with the complete address, and then duplicate information in specific fields which you need to search, especially the country and the name.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)