Pull records from one table to another at once

[Hector_Santilla]

I have a table “A” that needs to pull records form another table “B”. Table “B” has records of personnel activities based by date.
Person 1 may have 6 activities on certain date. Instead of pulling records one by one, I would like to pull all records based on person’s name and date.
Thanks in advance for your help

[Btbml]

What do you mean by “pull”? Are you talking about creating a report? Just having quick access to those 6 records?

[Hector_Santilla]

I have a table “A” to use for producing a report using page designer.

I need to populate some fields from records in table “B”. Table “B” have several people doing several activities (e.g. driving time, working time, assisting time) in a week. I need to retrieve each person with their activities from table “B” to table “A”.

Right now I’m using a link feature, but I am retrieving or “pulling” same person several times manually until done with their weekly activities and making math calculations for that person on same record.

[Btbml]

You should be able to do something like this. Its in my free base so I can’t add a page designer but you can add a field for “Table 2 Link” and then add columns to get multiple entries to show.

You can also add a few more tables with dates to get creative with date/week filtering

Airtable

2 tables - Airtable

Explore the "2 tables" base on Airtable.