How to show all records of the PatientCheckInOut table in a portal
Use a relationship based on X instead of the default = for the relationship used by your portal. (You can double click a relationship line to open a dialog where you can change the operator as well as specify other details for a given relatioship.)
I've done this but the portal just shows the wrong record. Even the patient check status is "Checked-In" in the PatientCheckInOut table, the porta which I put the 'x' relationship shows that the patient is "Called-in".
Thanks in advance
IF the portal is intended to show all records in the table, how can it possibly show the "wrong" record? (That's what you get with the X operator.)
If you only want the portal to show certain records, then you must either use a different operator or a portal filter (or both) to display the records you want to see in the portal.
Exactly what do you expect to see in the portal? Do you need to see multiple records or just one record/ (You describe this in your last post as though the portal displays a single record.) Which Records?
Okay. I'll detail the question. I'm having a problem to show all records form the other tables. I got three tables consist of Patient, PatientCheckInOut and Patient Clinical. Now in the Patient Clinical table, I need to display all records from PatientCheckInOut table. The fields in the portal consist of Patient::Name and PatientCheckInOut::Check Status. I've related the table Patient Clinical and PatientCheckInOut with 'x' relationship. The field "check status" shows correctly, but the field name are showing false records. For example, I got three patients with different check status. But in the portal, it shows the same patient and different check status. How can I solve this?
Now in the Patient Clinical table, I need to display all records from PatientCheckInOut table
That would be the Patient Clinical Layout... based on teh Pateint Clinical table. I'm not being picky just to be difficult, this is an important distinction to keep in mind as you can have many different layouts that are all based on the same table.
PatientClinical::anyField X PatientCheckInOut::anyfield
will list all records from PatientCheckInOut in a portal on a layout based on PatientClinical.
I got three patients with different check status. But in the portal, it shows the same patient and different check status. How can I solve this?
Since you have three tables, you need more than just the above relationship. Am I correct that the patient name field is a field defined in the Patient table? Since it is not a field in either of the above two tables, you need a relationship between PatientCheckInOut and Patient that looks like this:
PatientCheckInOut::_fkPatientID = Patient::__pkPatientID
where __pkPatientID is an auto-entered serial number.
You may need to create a new occurrence of the Patient table in order to set up this relationship.
Yes, I've already done the procedure you stated. But it's not working. I've attached a picture of my relationship.
This is my portal display :
You need this:
PatientCheckInOut 2::_fkPatientID = Patient 2::__pkPatientID
And the name field added to your portal row must be taken from Patient 2, not Patient.
Thank you very much :D. I really appreciate your help. It's working. :D