In the Relationships table, also create another secondary index on   
   RelativeID, then you can do a reverse search. This gets a little more   
   complicated.   
      
   Add an extra 2 options to RelativeType -5 = Son, 6=Daughter   
      
   Tom Krieg wrote:   
   > Ah! recursion. If it's only to one level, then it's easy.   
   >   
   > Persons   
   > Field1   PersonID (Meaningless Identifier)   
   > Field2   Name   
   > Field3   Birthday   
   > Field4   Address   
   > Primary Key = PersonID   
   >   
   > Relationships   
   > Field1   RecordID (Meaningless Identifier)   
   > Field1   PersonID - points to Persons record of this person   
   > Field2   RelativeType - 1 = Father; 2 = Mother, 3 = Brother, 4 = Sister   
   > Field2   RelativeID - points to PersonID of relative   
   > Primary Key = RecordID   
   > Secondary Index on PersonID + RelativeType + RelativeID (Unique)   
   >   
      
   --   
   Tom Krieg   
      
   ---------------   
   http://www.krieg.com.au   
   Please use the contact page to contact me via email   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)