Hi,   
   yes it's recursion. But I suppose more than one level. I would take it   
   as fas as plausible data takes me.   
   In the Table Relationships.Field1 (PersonsID) which field type do you   
   take? That is my main problem.   
      
      
   M.   
      
   On Wed, 23 Apr 2008 19:12:35 +1000, Tom Krieg <"Please use the website   
   contact form"> wrote:   
      
   >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)   
   >>   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)