Duplicate all child portal records related to a selected parental portal record
Relationship: Prescription < Drugs_rx
I have a Prescription portal button/script to select specific Prescription records. These will pull up Drugs_rx records related to that particular Prescription (Prescription::__PrescriptionID = Drug_rx::_PrescriptionID).
It's worth bearing in mind that if there's already a Prescription record, when I activate a new button/script it returns a duplicate of the last Prescription. If this occurs, I'd like it to also duplicate all the Drug_rx records related to that prescription. However, if there's no record in the Prescription portal, 'new Prescription' will simply create a new blank Prescription record and no Drug_rx records.