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 Relation****ps.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 Relation****ps 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
>>
>> Relation****ps
>> 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)
>>
|
