Limit Records in Portal ??

[jiehuang001]

I have a Patient table and a Visit table. In the patient table, there is a portal to display this patient's visits.

So, if a patient has 10 visits, the portal of this patient will show all 10 records.

How can I make this portal only show the visits whose status equals "failed", for example ??

Thanks very much.

Jie

[RalphL]

This will require a different relationship. You can modifiy your exsisting relationship by addin an AND where a global field in Patient = Visit::Status. Settiing the value of the global field to Failed would only show the patient visits for failed.