View all entries in a related table

Hi, I have a main table containing basic data about a patient including name and age. Each patient has a subtable containing consults including the field DateOfConsults and a diagnosis. Is there a way that I can create a view that will display the DateOfConsult for a certain date and the name of patients and the diagnosis for that specific DateOfConsult?