home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 8,325 of 9,834   
   Delbert to All   
   Key Fields   
   21 Mar 07 14:49:45   
   
   From: delllz@comcast.net   
      
   FOR PARADOX 8   
      
   I'm making a name and address database (no phone) with a dozen  fields; there   
   would be about 500 records.  The sequence is:  Last   
   Name, First Name, Organization, Street, City, etc.  Field type is A   
    for all fields.  I'm assigning a key to Last Name and First Name;    
   Organization   
   is not a good bet for a duplicate-breaker (thus having   
   a key ) because very few records will use Organization.    I could   
   assign a key to Street, but Organization is between First Name and Street,   
   putting Street out of sequence.   
      
   I could have the sequence as Last Name, First Name, Street, Organization--and   
   assign a key to the first three.  The mailing label Expert would allow me   
   to put Street and Organizaiton where they   
    belong for  mailing labels.   
      
   Please comment.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca