Trouble setting up new automation

[Debbie_Benkovic]

Hi everyone. I am trying to set up an automation where when a diagnosis field for a trip in one table is updated it finds the corresponding person (that is connected) in another table and updates a diagnosis field in that table where only different diagnosis is entered. Attached is what I have started. It doesn't run. I tried adding a find records step but couldn't configure the condition (screen grab also attached). 

Suggestions please!

[Pascal_Gallais- · Accepted solution]

Hello Debbie,

As far as i understand your problem, you should no link table "Passengers" to table "Diagnosis directory".

As Adam said, you should define a rollup field in table passengers as such:

I copied your base and modified the Flight requests in order to have 3 different diagnosis on 3 different lines for Bobba Flett, here is the result in passengers tables:

If needed, you can also filter this "diagnoses" rollup field to show only diagnoses for which status is either "In progress" or "Booked" in "flight requests" table:

Regards,

Pascal