Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Creating a Family Tree

Featured Replies

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?

  • Author

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?

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 ...

There is no image attached, so ...

It's not quite clear what you mean by "family tree". Filemaker can gather the data (i.e. the details of ancestors 5 generations back) but displaying it in a meaningful way is another matter altogether.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.