How To show only related record in List View REVISITED
I know this has been addressed before, but it has not worked for me...
I have built a patient database for my patients.
For simplicity's sake lets say we have two tables, PATIENTS, and VISITS, related via Pt_ID.
I want to have a list view of all the Visits related to a single patient.
I tried doing a script with the go to related record command, but this onlly works for the first time the layout is entered.
If I change the patient record to another patient, the related records from the visits table are not updated.
I tried using a onlayoutenter script with the gotorelatedrecord script step but this did not work.
I then tried using the perform find command but this did not work either, as it then got stuck to the found set and could not change patient records...
Any ideas would be greately appreciated.