You’ll need to link the records first, this will display the linked record’s primary key in table master table. Then, run a lookup on the associated records to display the specific columns you want.
Difficult to explain but…
Create 3 new “Linked” fie...