That's what I like to do too Hilmar -- that way you can have the address formatted properly for addressing letters etc (in the free-form field) and still have useful information for searching and filtering (in the specific fields). If you've got access to Outlook on the machines doing data capture, there's a reasonable address parser built into the Outlook Contact object. See http://www.civilsolutions.com.au/publications/parseaddress.htm for some sample code.

BTW, Lisa Slater raised this kind of thing some years ago (1998) when she pontificated about the FileAs field in Outlook contacts in her Fox Stuff -- see http://www.spacefold.com/lisa/lisa_fox.htm#fileas

Cheers,

Andrew

>>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.