Family Tree

[Thumper87]

I have a database used to manage all my reptiles i breed. each reptile record includes a "mother Field" and a "Father Field" i drew up a family tree, when i select the parents for that reptile they show up on the family tree. now what im trying to get on the family tree is to show that reptiles siblings...meaning i want all the reptile ID's that share the same mother and father, is this possible? Thanks! any help is much appreciated B)

[fseipel]

Yes, this is possible, you might wish to do it via a relationship (self-relate table, with itself, setting mother=mother, father=father).

You can then present the related records in a portal.

I suspect you are going to spend a lot more time on presentation than on structure, because conventional presentation would involve a tree drawing with lines interconnecting an indefinite number of relatives. I would achieve this by presenting the data in a WebViewer and using a data URL to position the fields and set the type size. This will also permit you to draw lines between them and still generate a schematic that is symmetrical and centered, and allow you to set the number of generations to go back.

[Lee Smith]

Take a look at this post by efen Link

Lee

[Thumper87]

Yes, this is possible, you might wish to do it via a relationship (self-relate table, with itself, setting mother=mother, father=father).

You can then present the related records in a portal.

I suspect you are going to spend a lot more time on presentation than on structure, because conventional presentation would involve a tree drawing with lines interconnecting an indefinite number of relatives. I would achieve this by presenting the data in a WebViewer and using a data URL to position the fields and set the type size. This will also permit you to draw lines between them and still generate a schematic that is symmetrical and centered, and allow you to set the number of generations to go back.

Perfect! Thanks so much works like a charm!

Edited September 14, 2010 by Guest

[Thumper87]

do you know how i would omit the record of the that is currently being viewed from the protal displaying siblings. i would like it to show only the sibblings since there is already a field for the currently viewed reptile record.

[fseipel]

You can apply a filter on the portal. In layout mode, double click the portal, check filter, and enter a formula. if the two self-related tables are designated reptile1 and reptile2, the filter might read reptile 1::IDNUM<>reptile 2::IDNUM. IDNUM is a unique identifier field -- it is preferred you not use the animal's name, since two names might be identical. You can generate IDNUM by clicking Options and selecting Serial Number under manage database.

Alternately you can change the relationship initially proposed, so that it includes reptile 1 IDNUM<> reptile 2 IDNUM. Then there is no need to filter the portal, where <> symbolizes not equal to.

Note that after creating IDNUM, it won't populate automatically, so do a records|replace field contents, and checkmark the use replace with serial numbers option, for existing records.

It may also be possible to generate a function determining genealogical proximity, or at least what line of the tree any given reptile resides on, so that 'distance' in generations between any two reptiles can be calculated.