I am trying to retrieve linked records from multiple tables with integromat. My database is set up for a vet like this:

Table 1: owner

Table 2: pet

Table 3: treatment

1 owner can have multiple pets and one pet can have multiple treatments.

With integromat I look for a criteria in the “treatment” table to retrieve certain records but this only returns data from the “treatment” table and I don’t know which pet or owner it is related to.

I tried feeding doing something like this in my formula: “pet’s name = pet’s name” where Integromat should return records where the pet’s name equals the other pet’s name field from the “treatment” table where they are linked. Unfortunately I get errors, Airtable can’t seem to use any criteria I throw at it to somehow return the linked records.

How should I go about retrieving the data linked to the record in other tables?