Automatically populating data in second table

[Jacqui_Birchall]

Hi All,

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!

[Kamille_Parks]

Jacqui_Birchall:

If Gerry arrives to kennels, I can add him to table 1, and then his name automatically shows up in table 2

Short Answer: Not without an integration.

Do you need to house exercise and food/medication in separate tables? Can you just have one table for dogs and one table for daily checkins?

Also this post may be beneficial to you:

Summary Table within Single Base Ask the community

I agree with @acdye that Zapier or Integromat would be your best bet. I prefer Integromat so that’s what I used to test the following solution. Table 1 has 75 rows each named for the item you collect data on each week, and one formula filled with calculate today’s week number and year. The calculated field can be hidden from view. Table 2 will hold all data for all weeks. This second table includes a autonumber as the primary field, the seven columns to discuss for a week, one link column poin…

[Justin_Barrett]

I agree with @Kamille_Parks that a reworking of your base structure will probably help. Ideally you’ll have a table that just tracks the dogs’ names and basic information. You could have other tables where you track specific things like medication, exercise, etc., but those tables would simply link to the main table of dogs, rather than having the dogs’ information entered again.