I wrote all this out and it didnt post, now i gotta type it all out again :(
Ok, so i have a table called Reptiles and fields for it:
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 occurence 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?