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

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.

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

2 tables - Airtable

Explore the "2 tables" base on Airtable.