Efficient way to move data from portal to portal?

[toffler]

I am curious as to the most efficient way to move data from one portal to another. I have a portal that displays drug name, dosage and instructions. I move the information from this portal to a patients drug list in another portal by first putting the text into a global field using:

SetField [ x;y ] where x is the global field and y the portal data

GoToField [ z ] where z is in the other portal

GoToPortalRow [ last ]

SetField [ z ; x ]

Is there a better way? Creating fields just to hold data temporarily seems wasteful.

Toffler

[Reed]

Sounds like you need at least three tables:

Drugs

Patients

A Join Table to track which Patients are on Which Drugs

On a layout corresponding to a patient record, one portal could display all possible drugs (filtering could reduce the number shown to a specific category of drugs) The other portal could show which drugs the current patient is taking. That portal would show records from the join table.

The join table only needs two fields The patient id and the drug id. To "move" a drug from the drug list to the patient drug list, you just need a script that grabs the drug id and creates a new record in the portal with that drug id (and the current patient id) To dislplay the detailed drug information in the join table portal, you just need a relationship to another occurrence of the drug table, then you can place drug description fields right in the join portal.

Hope this helps,

Dana