Updating Database With Data In Popup Window

I took a break from this program since I couldn't get it going. I just started it again yesterday and finally got it to pull data from the database to show past patient appointments in the appointment scheduler. Now I just need it to take the data from the pop up window and update the database with it so it's there after you close the program. I want it to update the EyeBase dataset and write it to the DB.

Here is the code so far:
Public Class Form1
Public Structure ScheduleOwner
Dim _index As String
Dim _description As String
Public Sub New(ByVal row As DataRow)
[Code] .....

Here is the form that pops up to enter patient information. I think I got it, I used this code:
Me.AppointmentTableAdapter1.Update(Me.TestAppointmentDataBaseDataSet1.Appointment)
And I can change things, click a save button, close it, then re-open to see the changes I made. New problem is when I try creating an appointment from scratch, I get an error saying "Column 'AppID' does not allow nulls." AppID is a column in the DB that I use to number the appointments. This seems like it's looking for a value when you create the appointment but I don't want it to. How can I have it ignore that?