Show all records in a portal

[redzwanlatif]

Hi. I got three tables called Patient, PatientCheckInOut and Clinical. Firstly patient will enter their information in the Patient table. Then a script will be trigered to add a new Check In record in the PatientCheckInOut table. Then doctors will see a list of patients waiting = (Table = PatientCheckInOut) . After that, doctor will click a button to go to the related record in Clinical table layout. The question is how to display a list of all waiting patient in the Clinical table layout ? How to show all records of the PatientCheckInOut table in a portal ? Thanks in advance