I am creating a database to keep track of the dogs boarding in my facility.
On one table I am wanting to keep track of the dogs feeding amounts and any medication, and then on the second table I am wanting to track the amount of exercise the dog has received.
The dogs housed within the facility changes frequently, so inputing the dogs name in to table 1 and table 2 daily seems like double handling. Is there any way for the dogs listed in table 1 to automatically generate in table 2?
E.g. If Gerry arrives to kennels, I can add him to table 1, and then his name automatically shows up in table 2?
Thanks so much in advance!