Is there a simple example app or video where when one row in one table is added or updated, columns in another table can be updated please?

Hi Help please - I am a beginner - I trying to filter a dropdown as follows but I can’t get the Outcome to filter because Diagnosis and Outcome are Ref s in the app. I can’t get the right Valid If Filter condition - sometimes I get can’t compare a te...