Perform Find based on field value???

[poly_paparas]

I have built a solution for my medical practice with a main table "Patients" and among others another related table "visits" (related via Pt_ID) with all the patient's visits.

I want to produce a report with all the information for a particular patient (from the "Patients" table) on the header and then all the visits of this particular patient on the body.

I tried using a portal, but that restricts the number of visits on the page.

I thought I could perform a find among the visits, using this criterion

Visits::Pt_ID=Patients::Pt_ID, or better still, copying the Pt_ID to a global field on the "Patients" table and using the gPt_ID for the search. The I could just sort the found set and display it in the Report Layout.

The problem is I cannot set the find criteria to a field's content. It seems that I have to give a specific value...

Can anyone help???

[transpower]

You need a join table: patient_visit. Print the report from the join table.

[T-Square]

Transpower--

I'm not sure a join table is the solution. Instead, poly could do it with a script, so:

Enter Find Mode[]

Set Field["PT_ID", "Patients::Pt_ID"]

Perform Find[]

Of course, there may be problems determining what value is IN Patients::Pt_ID, so it might be best to create and set a global field.

Then poly could display whatever report was necessary.