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)   
      
   Then you can look at a person and find all their relatives. For father,   
   look for RelativeType = 1, Mother = 2, all brothers = 3, all sisters = 4.   
      
   HTH   
      
   MichaelR@niemand.org wrote:   
   > Hi,   
   > I'd like to do a Table containing my Family-Relationship( Record no1:   
   > Me, Record No2: My Mother,...) I need a field in the Record which   
   > contains the pointer to the Record containing the data of that   
   > specific person.   
   >   
   > e.g.: Table Person   
   > RecordSet:   
   > Field1	Name;   
   > Field2	Birthday;   
   > Field3	Adress;   
   > Field4	Mother;      <--------- other Record in the same table;   
   > Field5	Father;       <----------   "          "                  " ;   
   >   
      
   --   
   Tom Krieg   
      
   ---------------   
   http://www.krieg.com.au   
   http://www.fam.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)