Single record for multiple entries

[MelHerndon]

Below are the files related to the database. This is an extremely simple database I want to create. It has 2 tables one is catPrimary and the other kittenPrimary. I have created one relationship so far linked to the ID fields. My question is about how best to keep multiple entries connected to only one record?

In this scenario the catPrimary will hold information about the parents, initial birth date/time, etc. The other will allow for a memo field date/time/and daily weight. I currently only have 2 kittens I need to monitor for the criteria. However in the future I may have a set of parents with say 6 kittens. I am new to databases and not sure what method to employ to keep all the daily entries associated with only the record pertaining to an individual kitten? I also have a field that lets me track the nail polish color used to keep track of which kitten is which in the litter if that will help.

Thank You,


Mel




https://www.dropbox.com/sh/boczbe4zl0g6p5k/d5B4nP2u4E

[June7]

This is like a geneology database. A kitten could become a parent - right? Or do you not allow that?

The daily entries need to be in a third table that has a field for the kitten ID as a foreign key that can link to the primary key field in kittenPrimary.

[MelHerndon]

This is like a geneology database. A kitten could become a parent - right? Or do you not allow that?

The daily entries need to be in a third table that has a field for the kitten ID as a foreign key that can link to the primary key field in kittenPrimary.

Yes indeed over time the kitten could become a parent. Thank for the help!

[June7]

If kitten will become parent then should not have table for parents and table for kittens. Should be one table of cats. However, a geneology db can be very complicated. Review https://www.accessforums.net/forms/r...rds-26006.html