Re: Data Model Question: International Address/Phone Nbrs
From: T. Scot Brown <anasb01_at_atlhp800.atl.cyanamid.com>
Date: Mon, 4 Apr 1994 19:33:53 GMT
Message-ID: <ANASB01.94Apr4153354_at_atlhp800.atl.cyanamid.com>
Date: Mon, 4 Apr 1994 19:33:53 GMT
Message-ID: <ANASB01.94Apr4153354_at_atlhp800.atl.cyanamid.com>
IMHO it is a very bad idea to use the state field to store countries. Add a country table. I have successfully handled foreign post codes in the same field as zip codes however, and similarly with phone numbers. You lose some formatting ease on forms, but it has been worth it in my experience.
Hope this helps. Received on Mon Apr 04 1994 - 21:33:53 CEST