I have a Parent form and Child form each with a corresponding table. The Parent table has ParentID as Auto number for the primary key, the Child table has childID as Auto number for the primary key and ParentID as the foreign key. The user enters a new parent or looks up an existing parent record (on the Parent form). I have a button on the parent form that when clicked will open the related child records (Child Form). I would like to add another button to the Parent form to add a new child for that parent. It would need to open the Child form and make the assocation with the ParentID and allow the user to enter the new child information.
Thanks!
Thanks!