Let me know if I’m understanding your situation correctly: The issue you’re facing comes from the fact that the status of a condition is indicated on the Conditions table, which means that there’s no way to filter by status on the Patients table without using a lookup (which returns text, not links).
One possible solution is to restructure your tables. Instead of having two tables – Patients and Conditions – you instead have three: Patients, Conditions, and (e.g.) Diagnoses. Instead of linking directly between Patients and Conditions, you’d instead link Patients to Diagnoses, then Diagnoses to Conditions.
The Patients file would only hold their personal details – DOB, contact, etc.; Conditions would only hold the generic details – possible causes, treatments, insurance codes; Diagnoses is where they come together – date of diagnoses, status of condition, images.
Having set up your database in this way, you could then see each patient’s current status by going to the Diagnoses table, filtering by status then grouping by patient. You’d still have clickable links to the Patients and Conditions tables.
Hope that helps!