Data Entry

  • Thread starter Thread starter jerryjo
  • Start date Start date
J

jerryjo

I have created a database using two tables. The key is my "LastName" column
in each file. I am able to edit records using a form that I have created but
can't create new records because the LastName being entered into the first
table does not have a matching LastName in the second table. What is the
procedure that would enter the new LastName into both files simultaneously?
Is there a way to use more than one control source to a single text box?

Thanks and enjoy the blessings of the day.
 
One of the easier ways to implement this is to make a form based on your
first (main) table, with a subform based on the second table. Join them on
the LastName column (if you're sure you really want only one Smith in your
first table...)
Now you can start by entering a new name in the main form, and enter as many
"child" records as you like in the subform. Each child record will
automatically get the LastName from the current record in the main form.

HTH
- Turtle
 
Back
Top