Get number of portal rows related to specific record

[poly_paparas]

Hi All,

I want to be able to get the number of portal rows in a record (essentially count the number of records in the related table for one given record).

My setup is as follows.

I have a layout pulling records from a table called patients, with the patient's details. There is a portal in this layout, pulling data from a related record called visits, which holds the patient's visits so far.

I want to be able to put a count of the number of visits on the layout. I tried various things, but I get the total number of records in the visits table, not the ones related to the particular patient

Any help would be appreciated.

George

[comment]

Try a calculation field (in the Patients table) =

Count ( Visits::PatientID )

---

P.S. Please update your profile with your version and OS.

[poly_paparas]

Try a calculation field (in the Patients table) =

Count ( Visits::PatientID )

---

P.S. Please update your profile with your version and OS.

Thank you very much for your help.

It worked like a charm...