Insert record in one table and it inserts a record in another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form that when i create a record in it i need it to create a
record in another form that will include the first records key value in the
second forms key value field. help please, thanks in advance
 
I have a main form that when i create a record in it i need it to create a
record in another form that will include the first records key value in the
second forms key value field. help please, thanks in advance
Click to expand...

This is NEVER either necessary nor is it a good idea. Creating such
empty "placeholder" records does you no good at all!

Instead, make the second form a Subform of the first one, using the ID
as the master/child link field. Then when you actually enter data onto
the subform, the ID will fill in for you automatically (but not until
you need it).

John W. Vinson[MVP]
 
Back
Top