Please disregard my questions from earlier today.  I realized that the first problems I had was that I had accidentally deleted the customerid field on my subform.  My second question was wondering why the customerid
field was not saving in the parent form and thus the appointment table but I now can understand that I was trying to make the form/subform relationship work backwards which apparently does not work.  

I do still need to figure out how to make this work.  So what I need to have happen is to be able to enter the
customer data into the subform and then somehow update the customerid field back in paren form.  Based on the reverse
relationship video it looks like I can use the doCmd.RunSQL "Insert Into" command to insert this field back into the
appointment table.  Is this possible?  and if so, how can I choose a specific record in which to insert the field value? In other words is there any kind of where condition that can be specified when using  the Insert Into command?

---

Reply from Richard Rost:

You really can't do this backwards. You could develop a different form where you can enter in both sets of data and then use some code to populate both, but you can't enter data into a subform until the parent has data.