Hi all,

This is likely to be a really basic question, but I just don't seem to get this to work.

I have a patient database. Each patient has multiple prescriptions that are filled at a specified pharmacy. Each patient has a "default" pharmacy where they usually (but not always) fill the scripts.

When I create a new prescription record (in a different table), I can read the patient default pharmacy value (I use name of the pharmacy as linked field) and store it in a text field in the new prescription record.

The thing I cannot get to work is this: I also link each prescription to a pharmacy (by name). I want that selection to have a default value that is the same as the patient's default pharmacy, but NOTHING.WORKS. 

I've lost count of how many ways I've tried to set the value of the linked pharmacy record in the prescription when the patient field changes... Currently the 'trigger after update' code in the patient field is:

let xPharm := Client.Pharmacies.'Pharmacy name';
select Pharmacies where 'Pharmacy name' = xPharm;
'Default pharmacy' := xPharm;
Pharmacy := xPharm

The extra lines below are just to ensure I've fished out the correct value from patient record

"Default pharmacy" is a dynamic select field (tried in desperation) - doesn't work.

"Pharmacy" is a text field to store the name of the pharmacy. This works.

"Pharmacies" is a linked record from subtable...

Sure this should not be hard...

Thanks in advance

Markus