AnsweredAssumed Answered

Self-join

Question asked by ucharles on Jun 2, 2014
Latest reply on Jul 5, 2015 by ucharles

Good Day Mr Wright

 

I am new to database development. I am so far self taught. I have in the past two year done my best to acquaint myself with everything relating to databases. So far, I have worked with MS Access and Filemaker Pro DBMSes.. Since my preferred platform is Mac OS X, Filemaker goes without say. I haven’t gone that deep into the complex intricacies of the Filemaker. I seem to have understood how relationship words, but self joining or recursive relationships still gives me a headache.

 

I have created a livestock database and I want to track which of the caves(livestock) belongs to which mother (livestock). In other words I want to be tracking the productivity of my cows. I have attached a picture to give you an idea, but you want to look at the complete file I could send it you. Please help.

 

Regards

Charles

<Screen Shot 2014-06-01 at 12.40.25 PM><Screen Shot 2014-06-01 at 12.48.11 PM><Screen Shot 2014-06-01 at 12.41.16 PM>

Outcomes