From: NSpamPlease_rodney1@bellsouth.net   
      
   Delbert,   
      
   Using the Street address as part of your tables KEY, you will stand a good   
   chance of creating duplicates.   
      
   Look at these 2 addresses:   
      
   1234 W. Sassafras Rd.   
   1234 Sasafras Road West   
      
   These 2 addresses are the same location but entered differently and also   
   misspelled.   You table would accept these as Different addresses.   
      
   To solve this, I created a library that reduces street addresses to a   
   numeric value.  It compensates for mis-spelled words (English) and also for   
   different Address Formats.   
      
   I would include a new Field and place the numeric value of the address in   
   that field... Use this field in combination with say your First Name field   
   to create a compound KEY.   
      
   The code for this can be found at:   
      
   http://www.ars-florida.com/PDOXboard   
      
   Look at article # 3,  "StreetPX"   
      
      
   --   
   ...   
       `·.¸¸.·´¯`·.¸¸.·´¯`·->  rodney   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)