Insert into c# sql

Question

I'm trying to insert records in a table in access and also in a grid thats in my program. Now my problem is tht I want to Insert columns that are from 2 seperate tables in my grid but insert only some of them in the actual access database. here is the general feel of this: Access database table name is Appointment the fields are PatientID, DoctorID,AppointmentNumber, AppointmentDate. All are text data types except the date. Then I have my grid which should display the PatientID,PatientSurname,PatientName,DoctorID,AppointmentDate. Now I am having trouble reading from these 2 tables in a single Insert Into...can anyone help
I am using c# and a 2007 access database
Thanks