Filter / Select all related data or rows and write the results to other table

Hi All,
My Child’s table has all the details of all the projects and materials. I can extract one type of material in scope and write the result to the other table. But if the project has many materials I would like to collect all those materials and add those new rows to the other table. can it be done?

0 1 116
1 REPLY 1

Steve
Platinum 4
Platinum 4
Top Labels in this Space