iFrame lists all possibilities

[GlenMcCabe]

Newbie here

I have built a browse / edit form which lists patients and edits. It appears to be working fine.

I added a run object iFrame to list the referrals for a patient. Problem is that all referrals are being shown in the iFrame. I have tried the iFrame in the same tab as the patient details and also in a seperate referral tab. Same list. Adding a new one seems to be fine.

SQL for the referral form is

SELECT *

FROM referral INNER JOIN patients

ON referral.patientID = patients.patid

Help would be appreciated.

[kev1n]

Aren't you missing a WHERE clauseto display only the records that belong to the patient?


WHERE patients.patid = '#RECORD_ID#'

[GlenMcCabe]

That line added gives no records in the list.

I assumed that adding #RECORD_ID# in the filter did the actual filtering.

thanks for trying

[admin]

Glen,

Hopefully, this will help...

https://www.youtube.com/watch?v=j5uvGMCPQRQ


Steven

[GlenMcCabe]

thanks folks.

Now sorted.

[admin]

.