John,

Thanks for your quick reply to my posting.

I don't quite understand your reply. Maybe my description is too complicated.

Briefly, I want to populate the ListBox with the list of dates from the SESSIONS table for the patient selected in the grid view.

For example, the following select statement would describe what I want to display:

SELECT date from SESSIONS WHERE SESSIONS.PATIENTID = SelectedPatientID

where SelectedPatientID is the value of PatientID form the record selected in the DataGridView.

Jim