searching within portals

[swf]

I have a layout of patients with 2 portals. The first displays all of a patients medication allergies. The second portal displays a patients medications. The second portal has an active field and sorts so that all the active medications are on top. It does display nonactive medications below that to see what may have changed recently. I know it is difficult to print from portals, therefore I would like to make a layout that for a given patient prints there name as the header, followed by their medication allergies and then their active medications.( I would need to limit the medications to where the active box is checked). So far I can only get it to print all of the medications. Thanks in advance for any help.

[dkemme]

In the table of medications, do a find for the active medications only, then print.

[swf]

When I do that it shows me all of the patients active medications not just the patient I am working on. In addition, I would like the layout or report to have patient name at the top, then all of their allergies, then their active medications.

[dkemme]

Do a search for all active medications and the patient your are intested in, use the same key you use in the relationship that shows the medications in the portal. Then at the top of the layout, put the patient's name using the relationship back to the patient table. I see the biggest problem with displaying the allergic medications, you can create a portal to allergies but would need to be shown as a portal, again difficult to print. I wonder if allergies need to be in a portal, I personally use a text field in the patient table.