Value List ... possessed by the ghosts of Haloween!

[ron G]

I am using FM 12 Advanced on OSX

There is something fundamental that I am missing. Here is the situation:

I have a 1 to many relationship between Patients and PatientStats

My layout is based on Patients

My portal is based on Patient Stats

I have a popup that displays Patients::_PKMemberID (yes I should change the name to Patients::PK_PatientID)

Problem: When I select a popup _PKMemberID, the associated Patient::NameFirst, Patient::NameMI etc does not change?

Plus the portal seems to not display propertly.

What causes this weird behavior?

[dansmith65]

Your layout is based on patients, so you should be performing a find to select a patient, rather than selecting them from a value list.

[ron G]

I set up a Cartesian (sic) join between Patients and Patients2. Then created a layout based on Patients2 and hooked up a GTRR script. This works well.

But, when I try the same thing with a POPUP (Using a GTRR script step On Save) I get spooks in my data.

My confusion is this: "Why can't I use a Popup to navigate Patients?" Shouldn't selecting the PK_PatientID in the POPUP take me to the appropriate Patient Record. After all, the layout is based on Patients and the POPUP selects the PK_PATIENTID...???

[dansmith65]

Shouldn't selecting the PK_PatientID in the POPUP take me to the appropriate Patient Record.

No, all a popup does is change the value of a field - it doesn't go to a related record or change the current active record.