2 Replies Latest reply on Mar 14, 2014 4:51 PM by Infodaisyhill

    Building a database for my breeding program

    Infodaisyhill

      Title

      Building a database for my breeding program

      Post

           I am building a database for my dog breeding program.  I created my ERD, but I keep running into snags.  I am trying to tract my Customers, dogs, litters and puppies.  I also need to include medical records and health testing records for my dogs, puppies and litters.  One of my issues is in litters.  Each litter has several puppies and each puppy needs their own record, but still needs to be tied to a particular litter.  I am looking for any suggestions on a better way to build my ERD.  Thanks in advance!

        • 1. Re: Building a database for my breeding program
          philmodjunk

               For tracking litters and puppies, create two tables, one for litters and one for dogs. Use a relationship to link each dog record to a specific litter record to show the litter into which it was born.

               Ultimately, this is a many to many self join relationship with the Litters table serving as the join between two occurrences of the dogs table. A dog can have many litters and a litter can list many puppies.

               Start with these relationships:

               Dogs-----<Litters>-----Puppies

               Dogs::__pkDogID = Litters::_fkParentID
               Puppies::__pkDogID = Litters::_fkPuppyID

               You can place a portal to Litters on the Dogs layout to list and select  Puppies records for each given Dogs record. Fields from Puppies can be included in the Portal to show additional info about each selected Puppies record and the _fkPuppyID field can be set up with a value list for selecting Puppies records by their ID field.

               For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained

          • 2. Re: Building a database for my breeding program
            Infodaisyhill

                 You have been extremely helpful.  Thank you:)