Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Creating a family tree


jcpython
 Share

Recommended Posts

Ok, so i have a table called Reptiles and fields for it:

ReptileID

ReptileCode

ReptileSex

ReptileMorph

ReptileSire

ReptileDame

ECT...

i need to setup a family tree, showing 5 generations,the reptilesire and reptiledame fields record the same data that would be inputed into the ReptilCode field, so they show the ReptileCode for sire and dame.

In the image attached you can see that the subject is the record being browsed, and the (ReptileCode) for the sire and dame is showing, but the other fields which just show the same data from the subject because i dont have fields setup to record that info of the sires and dames of each generation in the Reptiles table,

 

i know i can either add alot of extra fields to Reptiles table to record ll the info for each generation, or i can setup a relationship(s), problem is i have no clue how to set up the relationship, im betting its a table occurrence of the Reptiles table, but how many? and how i do i setup the relationship meaning = or x or the pound looking symbol. i need to show atleast 4 generations but would love to have 5.

 

should i set a relationship to achieve this?

 

 

geneology2.png

Link to comment
Share on other sites

Ok, so i have a table called Reptiles and fields for it:

ReptileID

ReptileCode

ReptileSex

ReptileMorph

ReptileSire

ReptileDame

ECT...

i need to setup a family tree, showing 5 generations,the reptilesire and reptiledame fields record the same data that would be inputed into the ReptilCode field, so they show the ReptileCode for sire and dame.

In the image attached you can see that the subject is the record being browsed, and the (ReptileCode) for the sire and dame is showing, but the other fields which just show the same data from the subject because i dont have fields setup to record that info of the sires and dames of each generation in the Reptiles table,

 

i know i can either add alot of extra fields to Reptiles table to record ll the info for each generation, or i can setup a relationship(s), problem is i have no clue how to set up the relationship, im betting its a table occurrence of the Reptiles table, but how many? and how i do i setup the relationship meaning = or x or the pound looking symbol. i need to show atleast 4 generations but would love to have 5.

 

should i set a relationship to achieve this?

 

 

geneology2.png

 

 

I did a quick database for what i want to achieve above, made a table called Reptiles with the above fields, and then duplicated that occurence for the sire and another for the dame, i related the fields like so:

 

 

 

Reptiles::ReptileSire -- = -- Reptiles Occurence Sire::ReptileTagCode

 

Reptiles::ReptileDame -- = -- Reptiles Occurence Dame::ReptileTagCode

 

 

 

it displayed the sire and dames info properly, and i can just repeat my steps buy creating occurences for for the sires and dames up to 5 generations, but thats gonna be alot of table occurences and im wondering if this is gonna be riddled with errors later on or if it is sloppy coding, maybe there is a better secure way of doing this?

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use